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_RL1_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 1048: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

1044: /* Variables used to hold the details of the payroll and assignment actions
1045: that are created. */
1046:
1047: l_payroll_action_created boolean := false;
1048: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1049: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1050: l_archive_item_id number;
1051:
1052: /* Variable holding the balance to be tested. */

Line 1081: l_report_type pay_payroll_actions.report_type%type;

1077: l_jurisdiction_code varchar2(30);
1078:
1079: /* general process variables */
1080:
1081: l_report_type pay_payroll_actions.report_type%type;
1082:
1083: -- Variables declared for bug 10399514
1084: l_person_on boolean ;
1085: l_report_cat pay_payroll_actions.report_category%type;

Line 1085: l_report_cat pay_payroll_actions.report_category%type;

1081: l_report_type pay_payroll_actions.report_type%type;
1082:
1083: -- Variables declared for bug 10399514
1084: l_person_on boolean ;
1085: l_report_cat pay_payroll_actions.report_category%type;
1086: l_state pay_payroll_actions.report_qualifier%type;
1087: l_report_format pay_report_format_mappings_f.report_format%type;
1088: -- Variables declared for bug 10399514
1089:

Line 1086: l_state pay_payroll_actions.report_qualifier%type;

1082:
1083: -- Variables declared for bug 10399514
1084: l_person_on boolean ;
1085: l_report_cat pay_payroll_actions.report_category%type;
1086: l_state pay_payroll_actions.report_qualifier%type;
1087: l_report_format pay_report_format_mappings_f.report_format%type;
1088: -- Variables declared for bug 10399514
1089:
1090: l_province pay_payroll_actions.report_qualifier%type;

Line 1090: l_province pay_payroll_actions.report_qualifier%type;

1086: l_state pay_payroll_actions.report_qualifier%type;
1087: l_report_format pay_report_format_mappings_f.report_format%type;
1088: -- Variables declared for bug 10399514
1089:
1090: l_province pay_payroll_actions.report_qualifier%type;
1091: l_value number;
1092: l_effective_date date;
1093: l_quarter_start date;
1094: l_quarter_end date;

Line 1156: pay_payroll_actions ppa

1152: asg.assignment_id assignment_id,
1153: asg.effective_end_date effective_end_date
1154: FROM per_all_assignments_f asg,
1155: pay_assignment_actions paa,
1156: pay_payroll_actions ppa
1157: WHERE ppa.effective_date between l_period_start
1158: and l_period_end
1159: AND ppa.action_type in ('R','Q','V','B','I')
1160: AND ppa.business_group_id +0 = l_bus_group_id

Line 1192: pay_payroll_actions ppa,

1188: asg.assignment_id assignment_id,
1189: asg.effective_end_date effective_end_date
1190: FROM per_all_assignments_f asg,
1191: pay_assignment_actions paa,
1192: pay_payroll_actions ppa,
1193: pay_population_ranges ppr
1194: WHERE ppa.effective_date between l_period_start
1195: and l_period_end
1196: AND ppa.action_type in ('R','Q','V','B','I')

Line 1251: pay_payroll_actions ppa,

1247: select paa.assignment_action_id
1248: from pay_assignment_actions paa,
1249: per_all_assignments_f paf,
1250: per_all_people_f ppf,
1251: pay_payroll_actions ppa,
1252: pay_action_classifications pac
1253: where ppf.person_id = cp_person_id
1254: and paf.person_id = ppf.person_id
1255: and paa.assignment_id = paf.assignment_id

Line 1291: from pay_payroll_actions

1287: l_report_cat,
1288: -- Added for bug 10399514
1289: l_bus_group_id,
1290: l_pre_organization_id
1291: from pay_payroll_actions
1292: where payroll_action_id = pactid;
1293:
1294: hr_utility.trace('getting dates');
1295:

Line 1732: from pay_payroll_actions

1728: /*hr_utility.trace_on('Y','RL1'); */
1729:
1730: select to_char(effective_date,'YYYY'),business_group_id
1731: into l_taxation_year,l_business_group_id
1732: from pay_payroll_actions
1733: where payroll_action_id = p_payroll_action_id;
1734:
1735: open employer_info;
1736:

Line 2336: from pay_payroll_actions ppa,

2332:
2333: select decode(hoi.org_information3,'Y',hoi.organization_id,
2334: hoi.org_information20)
2335: into l_transmitter_name1
2336: from pay_payroll_actions ppa,
2337: hr_organization_information hoi,
2338: hr_all_organization_units hou
2339: WHERE hou.business_group_id = ppa.business_group_id
2340: and hoi.organization_id = hou.organization_id

Line 2471: pay_payroll_actions ppa,

2467: select /*+ Ordered */ paa.assignment_action_id
2468: from per_all_people_f ppf,
2469: per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,
2474: ff_contexts fc
2475: where ppf.person_id = cp_person_id

Line 2495: from pay_payroll_actions ppa,

2491: order by paa.action_sequence desc;
2492:
2493: cursor c_all_gres_for_further_info(asgactid number) is
2494: select hoi.organization_id
2495: from pay_payroll_actions ppa,
2496: pay_assignment_actions paa,
2497: hr_organization_information hoi
2498: where paa.assignment_action_id = asgactid
2499: and ppa.payroll_action_id = paa.payroll_action_id

Line 2541: from pay_payroll_actions

2537: hr_utility.trace('l_payroll_action_id '|| to_char(l_payroll_action_id));
2538:
2539: select business_group_id
2540: into l_business_group_id
2541: from pay_payroll_actions
2542: where payroll_action_id = l_payroll_action_id;
2543:
2544: end if;
2545:

Line 2956: from pay_payroll_actions ppa,

2952:
2953: cursor c_all_gres(asgactid number) is
2954: select hoi.organization_id ,
2955: hoi.org_information5
2956: from pay_payroll_actions ppa,
2957: pay_assignment_actions paa,
2958: hr_organization_information hoi
2959: where paa.assignment_action_id = asgactid
2960: and ppa.payroll_action_id = paa.payroll_action_id

Line 2971: from pay_payroll_actions ppa,

2967:
2968: cursor c_all_gres_for_footnote(asgactid number) is
2969: select hoi.organization_id ,
2970: hoi.org_information5
2971: from pay_payroll_actions ppa,
2972: pay_assignment_actions paa,
2973: hr_organization_information hoi
2974: where paa.assignment_action_id = asgactid
2975: and ppa.payroll_action_id = paa.payroll_action_id

Line 2993: pay_payroll_actions ppa,

2989: */
2990: cursor c_all_gres_for_person(cp_asg_id number,cp_eff_date date) is
2991: select distinct paa.tax_unit_id
2992: from pay_assignment_actions paa,
2993: pay_payroll_actions ppa,
2994: per_all_assignments_f paf
2995: where paa.assignment_id = cp_asg_id
2996: and paf.assignment_id = cp_asg_id
2997: and paf.assignment_id = paa.assignment_id

Line 3077: , pay_payroll_actions run_ppa

3073: , pay_element_types_f pet
3074: , pay_input_values_f piv1
3075: , pay_input_values_f piv2
3076: , pay_assignment_actions run_paa
3077: , pay_payroll_actions run_ppa
3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf

Line 3079: , pay_payroll_actions arch_ppa

3075: , pay_input_values_f piv2
3076: , pay_assignment_actions run_paa
3077: , pay_payroll_actions run_ppa
3078: , pay_assignment_actions arch_paa
3079: , pay_payroll_actions arch_ppa
3080: , per_all_assignments_f arch_paf
3081: , per_all_assignments_f all_paf
3082: , hr_all_organization_units hou
3083: , hr_organization_information hoi

Line 3156: from pay_payroll_actions ppa,pay_assignment_actions paa

3152: and fdi.user_name = 'CAEOY_RL1_PROVINCE_OF_EMPLOYMENT';
3153:
3154: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
3155: select ppa.report_type
3156: from pay_payroll_actions ppa,pay_assignment_actions paa
3157: where paa.assignment_action_id = cp_locked_actid
3158: and ppa.payroll_action_id = paa.payroll_action_id;
3159:
3160: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 3187: pay_payroll_actions ppa,

3183: select /*+ Ordered */ paa.assignment_action_id
3184: from per_all_people_f ppf,
3185: per_all_assignments_f paf,
3186: pay_assignment_actions paa,
3187: pay_payroll_actions ppa,
3188: pay_action_classifications pac,
3189: pay_action_contexts pac1,
3190: ff_contexts fc
3191: where ppf.person_id = cp_person_id

Line 3219: pay_payroll_actions ppa,

3215: select paa.assignment_action_id
3216: from pay_assignment_actions paa,
3217: per_all_assignments_f paf,
3218: per_all_people_f ppf,
3219: pay_payroll_actions ppa,
3220: pay_action_classifications pac
3221: where ppf.person_id = cp_person_id
3222: and paf.person_id = ppf.person_id
3223: and paf.assignment_id = paa.assignment_id

Line 3273: from pay_payroll_actions

3269: select pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3270: legislative_parameters),
3271: business_group_id
3272: into l_pre_organization_id,l_business_group_id
3273: from pay_payroll_actions
3274: where payroll_action_id = l_payroll_action_id;
3275:
3276: eoy_archive_gre_data(p_payroll_action_id =>l_payroll_action_id,
3277: p_pre_organization_id=>l_pre_organization_id);

Line 4956: from pay_payroll_actions

4952: ,legislative_parameters))
4953: into lv_fapp_effective_date,
4954: lv_fapp_report_type,
4955: ln_fapp_pre_org_id
4956: from pay_payroll_actions
4957: where payroll_action_id = l_payroll_action_id;
4958:
4959: hr_utility.trace('Prov Amend Pre-Process Pactid :'||
4960: to_char(l_payroll_action_id));

Line 5116: from pay_payroll_actions

5112: into l_pre_organization_id,
5113: l_year_start,
5114: l_year_end,
5115: l_business_group
5116: from pay_payroll_actions
5117: where payroll_action_id = pactid;
5118:
5119: sqlstr := 'select distinct asg.person_id
5120: from pay_all_payrolls_f ppy,

Line 5121: pay_payroll_actions ppa,

5117: where payroll_action_id = pactid;
5118:
5119: sqlstr := 'select distinct asg.person_id
5120: from pay_all_payrolls_f ppy,
5121: pay_payroll_actions ppa,
5122: pay_assignment_actions paa,
5123: per_all_assignments_f asg,
5124: pay_payroll_actions ppa1
5125: where ppa1.payroll_action_id = :payroll_action_id

Line 5124: pay_payroll_actions ppa1

5120: from pay_all_payrolls_f ppy,
5121: pay_payroll_actions ppa,
5122: pay_assignment_actions paa,
5123: per_all_assignments_f asg,
5124: pay_payroll_actions ppa1
5125: where ppa1.payroll_action_id = :payroll_action_id
5126: and ppa.effective_date between
5127: fnd_date.canonical_to_date('''||
5128: fnd_date.date_to_canonical(l_year_start)||''') and