APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 849: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

845: /* Variables used to hold the details of the payroll and assignment actions
846: that are created. */
847:
848: l_payroll_action_created boolean := false;
849: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
850: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
851: l_archive_item_id number;
852:
853: /* Variable holding the balance to be tested. */

Line 882: l_report_type pay_payroll_actions.report_type%type;

878: l_jurisdiction_code varchar2(30);
879:
880: /* general process variables */
881:
882: l_report_type pay_payroll_actions.report_type%type;
883: l_province pay_payroll_actions.report_qualifier%type;
884: l_value number;
885: l_effective_date date;
886: l_quarter_start date;

Line 883: l_province pay_payroll_actions.report_qualifier%type;

879:
880: /* general process variables */
881:
882: l_report_type pay_payroll_actions.report_type%type;
883: l_province pay_payroll_actions.report_qualifier%type;
884: l_value number;
885: l_effective_date date;
886: l_quarter_start date;
887: l_quarter_end date;

Line 944: pay_payroll_actions ppa

940: asg.assignment_id assignment_id,
941: asg.effective_end_date effective_end_date
942: FROM per_all_assignments_f asg,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa
945: WHERE ppa.effective_date between l_period_start
946: and l_period_end
947: AND ppa.action_type in ('R','Q','V','B','I')
948: AND ppa.business_group_id +0 = l_bus_group_id

Line 1003: pay_payroll_actions ppa,

999: select paa.assignment_action_id
1000: from pay_assignment_actions paa,
1001: per_all_assignments_f paf,
1002: per_all_people_f ppf,
1003: pay_payroll_actions ppa,
1004: pay_action_classifications pac
1005: where ppf.person_id = cp_person_id
1006: and paf.person_id = ppf.person_id
1007: and paa.assignment_id = paf.assignment_id

Line 1036: from pay_payroll_actions

1032: into l_effective_date,
1033: l_report_type,
1034: l_bus_group_id,
1035: l_pre_org_id
1036: from pay_payroll_actions
1037: where payroll_action_id = pactid;
1038:
1039: hr_utility.trace('getting dates');
1040:

Line 1362: from pay_payroll_actions

1358: initialization_process('PRE_DATA');
1359:
1360: select to_char(effective_date,'YYYY'),business_group_id,effective_date
1361: into l_taxation_year,l_business_group_id,l_effective_date
1362: from pay_payroll_actions
1363: where payroll_action_id = p_payroll_action_id;
1364:
1365: open employer_info;
1366:

Line 2033: pay_payroll_actions ppa,

2029: select paa.assignment_action_id
2030: from pay_assignment_actions paa,
2031: per_all_assignments_f paf,
2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,
2035: pay_action_contexts pac1,
2036: ff_contexts fc
2037: where ppf.person_id = cp_person_id

Line 2114: from pay_payroll_actions

2110: legislative_parameters),
2111: business_group_id
2112: into l_pre_org_id,
2113: l_business_group_id
2114: from pay_payroll_actions
2115: where payroll_action_id = l_payroll_action_id;
2116:
2117: exception when no_data_found then
2118: /* need a pop-message */

Line 3130: from pay_payroll_actions

3126: legislative_parameters))
3127: into lv_fapp_effective_date,
3128: lv_fapp_report_type,
3129: ln_fapp_pre_org_id
3130: from pay_payroll_actions
3131: where payroll_action_id = l_payroll_action_id;
3132:
3133: hr_utility.trace('lv_fapp_report_type :'||lv_fapp_report_type);
3134:

Line 3231: from pay_payroll_actions

3227: into l_pre_org_id,
3228: l_year_start,
3229: l_year_end,
3230: l_business_group
3231: from pay_payroll_actions
3232: where payroll_action_id = pactid;
3233:
3234: hr_utility.trace('in range cursor step 1');
3235:

Line 3238: pay_payroll_actions ppa,

3234: hr_utility.trace('in range cursor step 1');
3235:
3236: sqlstr := 'select distinct asg.person_id
3237: from pay_all_payrolls_f ppy,
3238: pay_payroll_actions ppa,
3239: pay_assignment_actions paa,
3240: per_all_assignments_f asg,
3241: pay_payroll_actions ppa1
3242: where ppa1.payroll_action_id = :payroll_action_id

Line 3241: pay_payroll_actions ppa1

3237: from pay_all_payrolls_f ppy,
3238: pay_payroll_actions ppa,
3239: pay_assignment_actions paa,
3240: per_all_assignments_f asg,
3241: pay_payroll_actions ppa1
3242: where ppa1.payroll_action_id = :payroll_action_id
3243: and ppa.effective_date between
3244: fnd_date.canonical_to_date('''||
3245: fnd_date.date_to_canonical(l_year_start)||''') and