eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 908: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

904: /* Variables used to hold the details of the payroll and assignment actions
905: that are created. */
906:
907: l_payroll_action_created boolean := false;
908: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
909: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
910: l_archive_item_id number;
911:
912: /* Variable holding the balance to be tested. */

Line 941: l_report_type pay_payroll_actions.report_type%type;

937: l_jurisdiction_code varchar2(30);
938:
939: /* general process variables */
940:
941: l_report_type pay_payroll_actions.report_type%type;
942:
943: -- Variables declared for bug 10399514
944: l_person_on boolean ;
945: l_report_cat pay_payroll_actions.report_category%type;

Line 945: l_report_cat pay_payroll_actions.report_category%type;

941: l_report_type pay_payroll_actions.report_type%type;
942:
943: -- Variables declared for bug 10399514
944: l_person_on boolean ;
945: l_report_cat pay_payroll_actions.report_category%type;
946: l_state pay_payroll_actions.report_qualifier%type;
947: l_report_format pay_report_format_mappings_f.report_format%type;
948: -- Variables declared for bug 10399514
949:

Line 946: l_state pay_payroll_actions.report_qualifier%type;

942:
943: -- Variables declared for bug 10399514
944: l_person_on boolean ;
945: l_report_cat pay_payroll_actions.report_category%type;
946: l_state pay_payroll_actions.report_qualifier%type;
947: l_report_format pay_report_format_mappings_f.report_format%type;
948: -- Variables declared for bug 10399514
949:
950: l_province pay_payroll_actions.report_qualifier%type;

Line 950: l_province pay_payroll_actions.report_qualifier%type;

946: l_state pay_payroll_actions.report_qualifier%type;
947: l_report_format pay_report_format_mappings_f.report_format%type;
948: -- Variables declared for bug 10399514
949:
950: l_province pay_payroll_actions.report_qualifier%type;
951: l_value number;
952: l_effective_date date;
953: l_quarter_start date;
954: l_quarter_end date;

Line 1011: pay_payroll_actions ppa

1007: asg.assignment_id assignment_id,
1008: asg.effective_end_date effective_end_date
1009: FROM per_all_assignments_f asg,
1010: pay_assignment_actions paa,
1011: pay_payroll_actions ppa
1012: WHERE ppa.effective_date between l_period_start
1013: and l_period_end
1014: AND ppa.action_type in ('R','Q','V','B','I')
1015: AND ppa.business_group_id +0 = l_bus_group_id

Line 1047: pay_payroll_actions ppa,

1043: asg.assignment_id assignment_id,
1044: asg.effective_end_date effective_end_date
1045: FROM per_all_assignments_f asg,
1046: pay_assignment_actions paa,
1047: pay_payroll_actions ppa,
1048: pay_population_ranges ppr
1049: WHERE ppa.effective_date between l_period_start
1050: and l_period_end
1051: AND ppa.action_type in ('R','Q','V','B','I')

Line 1110: pay_payroll_actions ppa,

1106: select paa.assignment_action_id
1107: from pay_assignment_actions paa,
1108: per_all_assignments_f paf,
1109: per_all_people_f ppf,
1110: pay_payroll_actions ppa,
1111: pay_action_classifications pac
1112: where ppf.person_id = cp_person_id
1113: and paf.person_id = ppf.person_id
1114: and paa.assignment_id = paf.assignment_id

Line 1151: from pay_payroll_actions

1147: l_report_cat,
1148: -- Added for bug 10399514
1149: l_bus_group_id,
1150: l_pre_org_id
1151: from pay_payroll_actions
1152: where payroll_action_id = pactid;
1153:
1154: hr_utility.trace('getting dates');
1155:

Line 1532: from pay_payroll_actions

1528: initialization_process('PRE_DATA');
1529:
1530: select to_char(effective_date,'YYYY'),business_group_id,effective_date
1531: into l_taxation_year,l_business_group_id,l_effective_date
1532: from pay_payroll_actions
1533: where payroll_action_id = p_payroll_action_id;
1534:
1535: open employer_info;
1536:

Line 2156: pay_payroll_actions ppa,

2152: select paa.assignment_action_id
2153: from pay_assignment_actions paa,
2154: per_all_assignments_f paf,
2155: per_all_people_f ppf,
2156: pay_payroll_actions ppa,
2157: pay_action_classifications pac,
2158: pay_action_contexts pac1,
2159: ff_contexts fc
2160: where ppf.person_id = cp_person_id

Line 2213: from pay_payroll_actions

2209: legislative_parameters),
2210: business_group_id
2211: into l_pre_org_id,
2212: l_business_group_id
2213: from pay_payroll_actions
2214: where payroll_action_id = l_payroll_action_id;
2215:
2216: exception when no_data_found then
2217: /* need a pop-message */

Line 2739: pay_payroll_actions ppa,

2735: select paa.assignment_action_id
2736: from pay_assignment_actions paa,
2737: per_all_assignments_f paf,
2738: per_all_people_f ppf,
2739: pay_payroll_actions ppa,
2740: pay_action_classifications pac,
2741: pay_action_contexts pac1,
2742: ff_contexts fc
2743: where ppf.person_id = cp_person_id

Line 2820: from pay_payroll_actions

2816: legislative_parameters),
2817: business_group_id
2818: into l_pre_org_id,
2819: l_business_group_id
2820: from pay_payroll_actions
2821: where payroll_action_id = l_payroll_action_id;
2822:
2823: exception when no_data_found then
2824: /* need a pop-message */

Line 3943: from pay_payroll_actions

3939: legislative_parameters))
3940: into lv_fapp_effective_date,
3941: lv_fapp_report_type,
3942: ln_fapp_pre_org_id
3943: from pay_payroll_actions
3944: where payroll_action_id = l_payroll_action_id;
3945:
3946: hr_utility.trace('lv_fapp_report_type :'||lv_fapp_report_type);
3947:

Line 4078: from pay_payroll_actions

4074: into l_pre_org_id,
4075: l_year_start,
4076: l_year_end,
4077: l_business_group
4078: from pay_payroll_actions
4079: where payroll_action_id = pactid;
4080:
4081: hr_utility.trace('in range cursor step 1');
4082:

Line 4085: pay_payroll_actions ppa,

4081: hr_utility.trace('in range cursor step 1');
4082:
4083: sqlstr := 'select distinct asg.person_id
4084: from pay_all_payrolls_f ppy,
4085: pay_payroll_actions ppa,
4086: pay_assignment_actions paa,
4087: per_all_assignments_f asg,
4088: pay_payroll_actions ppa1
4089: where ppa1.payroll_action_id = :payroll_action_id

Line 4088: pay_payroll_actions ppa1

4084: from pay_all_payrolls_f ppy,
4085: pay_payroll_actions ppa,
4086: pay_assignment_actions paa,
4087: per_all_assignments_f asg,
4088: pay_payroll_actions ppa1
4089: where ppa1.payroll_action_id = :payroll_action_id
4090: and ppa.effective_date between
4091: fnd_date.canonical_to_date('''||
4092: fnd_date.date_to_canonical(l_year_start)||''') and