DBA Data[Home] [Help]

APPS.PAY_CA_T4A_REG dependencies on FF_USER_ENTITIES

Line 36: l_uid_tax_year ff_user_entities.user_entity_id%TYPE;

32:
33: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
34: l_payroll_id number;
35: leg_param pay_payroll_actions.legislative_parameters%type;
36: l_uid_tax_year ff_user_entities.user_entity_id%TYPE;
37: l_uid_tax_unit_id ff_user_entities.user_entity_id%TYPE;
38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;
39: --
40: begin

Line 37: l_uid_tax_unit_id ff_user_entities.user_entity_id%TYPE;

33: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
34: l_payroll_id number;
35: leg_param pay_payroll_actions.legislative_parameters%type;
36: l_uid_tax_year ff_user_entities.user_entity_id%TYPE;
37: l_uid_tax_unit_id ff_user_entities.user_entity_id%TYPE;
38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;
39: --
40: begin
41: --hr_utility.trace_on('Y','ORACLE');

Line 38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;

34: l_payroll_id number;
35: leg_param pay_payroll_actions.legislative_parameters%type;
36: l_uid_tax_year ff_user_entities.user_entity_id%TYPE;
37: l_uid_tax_unit_id ff_user_entities.user_entity_id%TYPE;
38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;
39: --
40: begin
41: --hr_utility.trace_on('Y','ORACLE');
42: hr_utility.trace('begining of range_cursor 1 ');

Line 108: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;

104: l_report_format pay_report_format_mappings_f.report_format%type;
105: -- Variables declared for bug 10399514
106:
107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
108: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
109: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
110: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
111: l_session_date pay_payroll_actions.effective_date%TYPE;
112: lv_per_id varchar2(30);

Line 109: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;

105: -- Variables declared for bug 10399514
106:
107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
108: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
109: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
110: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
111: l_session_date pay_payroll_actions.effective_date%TYPE;
112: lv_per_id varchar2(30);
113: