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_NO_EOY_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 148: -- FROM pay_assignment_actions paa

144: -- ,p_reporting_code IN VARCHAR2) IS
145: -- SELECT asg_act.action_information5 person_id
146: -- ,asg_act.action_information6 tax_municipality
147: -- ,TO_NUMBER(rep_cde.action_information3) amount
148: -- FROM pay_assignment_actions paa
149: -- ,pay_action_information asg_act
150: -- ,pay_action_information rep_cde
151: -- WHERE paa.payroll_action_id = p_payroll_action_id
152: -- AND asg_act.action_context_type = 'AAP'

Line 1228: FROM pay_assignment_actions paa

1224: , DECODE(orginf2.org_information5
1225: ,'Y', orginf2.org_information1
1226: ,orginf1.org_information1) org_number
1227:
1228: FROM pay_assignment_actions paa
1229: ,pay_payroll_actions ppa
1230: ,pay_action_contexts pac1
1231: ,pay_action_contexts pac2
1232: ,ff_contexts ctx1

Line 1272: ,pay_assignment_actions paa

1268: ,p_legal_employer_id IN NUMBER
1269: ,p_assg_id IN NUMBER) IS
1270: SELECT max(paa.assignment_action_id)
1271: FROM pay_payroll_actions ppa
1272: ,pay_assignment_actions paa
1273: WHERE ppa.business_group_id = p_business_group_id
1274: AND ppa.action_type IN ('R','Q','I','B')
1275: AND ppa.action_status = 'C'
1276: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1814: ,pay_assignment_actions paa

1810: ,MAX(ppa.effective_date) effective_date
1811: ,MAX(asg.effective_end_date) effective_end_date
1812: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1813: FROM per_all_assignments_f asg
1814: ,pay_assignment_actions paa
1815: ,pay_payroll_actions ppa
1816: ,pay_action_information ai
1817: ,pay_action_contexts ac1
1818: ,ff_contexts ctx1

Line 1994: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;

1990: --
1991: --
1992: -- Create assignment action for archive process.
1993: --
1994: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;
1995: hr_nonrun_asact.insact
1996: (l_assact_id
1997: ,l_asg_rec.assignment_id
1998: ,p_payroll_action_id

Line 2057: ,pay_assignment_actions paa

2053: ,asg_act.action_information4 ni_zone
2054: ,asg_act.action_information6 tax_municipality_id
2055: ,asg_act.action_information8 municipality_code
2056: FROM pay_action_information asg_act
2057: ,pay_assignment_actions paa
2058: WHERE asg_act.action_information_category = 'EMEA REPORT INFORMATION'
2059: AND asg_act.action_information1 = 'ASG_ACT_INFO'
2060: AND asg_act.action_context_type = 'AAP'
2061: AND asg_act.action_context_id = paa.assignment_action_id

Line 2112: ,pay_assignment_actions paa

2108: -- ,pivf.uom dtype
2109: FROM pay_action_information cde_dtl
2110: ,pay_action_information cde_info_dtl
2111: ,pay_element_type_extra_info eei
2112: ,pay_assignment_actions paa
2113: ,pay_action_contexts ac1
2114: ,ff_contexts ctx1
2115: ,pay_action_contexts ac2
2116: ,ff_contexts ctx2

Line 2288: FROM pay_assignment_actions paa

2284: ,p_report_date IN DATE
2285: ,l_element_name IN VARCHAR2 ) IS
2286: SELECT rrv.result_value value
2287: ,pivf.uom dtype
2288: FROM pay_assignment_actions paa
2289: ,pay_action_contexts ac1
2290: ,ff_contexts ctx1
2291: ,pay_action_contexts ac2
2292: ,ff_contexts ctx2

Line 2364: FROM pay_assignment_actions paa

2360: ,petf.element_type_id element_type_id
2361: ,rr.run_result_id rr_id
2362: ,petf.element_name element_name
2363: ,ppa.action_type action_type
2364: FROM pay_assignment_actions paa
2365: ,pay_action_contexts ac1
2366: ,ff_contexts ctx1
2367: ,pay_action_contexts ac2
2368: ,ff_contexts ctx2

Line 2449: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;

2445: l_Days NUMBER;
2446: status_616 NUMBER;
2447: l_index_616 NUMBER;
2448: l_code_616 code_616;
2449: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;
2450: r_retro_rec csr_retro%rowtype;
2451: --
2452: BEGIN
2453: hr_utility.set_location('Entering ' || l_proc_name, 10);

Line 2457: from pay_assignment_actions paa

2453: hr_utility.set_location('Entering ' || l_proc_name, 10);
2454: --
2455: /* Select Payroll_action_id
2456: into l_payroll_action_id
2457: from pay_assignment_actions paa
2458: where paa.assignment_action_id = p_assignment_action_id;
2459:
2460: set_parameters(l_payroll_action_id);
2461:

Line 3158: FROM pay_assignment_actions paa

3154: CURSOR csr_LE_PER_BELOW_REP_LIMIT
3155: (p_payroll_action_id IN NUMBER) IS
3156: SELECT le_lu.action_information2 legal_employer_id
3157: ,asg_act.action_information5 person_id
3158: FROM pay_assignment_actions paa
3159: ,pay_action_information le_lu
3160: ,pay_action_information asg_act
3161: ,pay_action_information rep_cde
3162: ,pay_action_information cde_dtl

Line 3197: ,pay_assignment_actions paa

3193: SELECT asg_act.action_information_id
3194: ,asg_act.object_version_number
3195: ,paa.assignment_id
3196: FROM pay_action_information asg_act
3197: ,pay_assignment_actions paa
3198: WHERE asg_act.action_information_category = 'EMEA REPORT INFORMATION'
3199: AND asg_act.action_information1 = 'ASG_ACT_INFO'
3200: AND asg_act.action_information2 = p_legal_employer_id
3201: AND asg_act.action_information5 = p_person_id

Line 3234: FROM pay_assignment_actions paa

3230: ,rep_cde.action_information21 cinfo7 --2009 changes
3231: ,rep_cde.action_information22 cinfo8 --2009 changes
3232: ,rep_cde.action_information23 cinfo9 --2009 changes
3233: ,rep_cde.action_information24 cinfo10 --2009 changes
3234: FROM pay_assignment_actions paa
3235: ,pay_action_information asg_act
3236: ,pay_action_information rep_cde
3237: ,pay_action_information cde_dtl
3238: WHERE paa.payroll_action_id = p_payroll_action_id

Line 3274: FROM pay_assignment_actions paa,pay_action_information asg_act,pay_action_information rep_cde

3270: ,min(rep_cde.action_information11) cinfo1
3271: ,max(rep_cde.action_information12) cinfo2
3272: ,rep_cde.action_information13 cinfo3
3273: ,rep_cde.action_information14 cinfo4
3274: FROM pay_assignment_actions paa,pay_action_information asg_act,pay_action_information rep_cde
3275: WHERE paa.payroll_action_id = p_payroll_action_id
3276: AND asg_act.action_context_type = 'AAP'
3277: AND asg_act.action_context_id = paa.assignment_action_id
3278: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 3328: FROM pay_assignment_actions paa,pay_action_information asg_act,pay_action_information rep_cde

3324: ,rep_cde.action_information11 cinfo1
3325: ,rep_cde.action_information12 cinfo2
3326: ,rep_cde.action_information13 cinfo3
3327: ,rep_cde.action_information14 cinfo4
3328: FROM pay_assignment_actions paa,pay_action_information asg_act,pay_action_information rep_cde
3329: WHERE paa.payroll_action_id = p_payroll_action_id
3330: AND asg_act.action_context_type = 'AAP'
3331: AND asg_act.action_context_id = paa.assignment_action_id
3332: AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'

Line 3378: FROM pay_assignment_actions paa

3374: ,rep_cde.action_information21 cinfo7 --2009 changes
3375: ,rep_cde.action_information22 cinfo8 --2009 changes
3376: ,rep_cde.action_information23 cinfo9 --2009 changes
3377: ,rep_cde.action_information24 cinfo10 --2009 changes
3378: FROM pay_assignment_actions paa
3379: ,pay_action_information asg_act
3380: ,pay_action_information rep_cde
3381: ,pay_action_information cde_dtl
3382: WHERE paa.payroll_action_id = p_payroll_action_id

Line 4375: FROM pay_assignment_actions paa

4371: ,0)) sum_zone5
4372: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4373: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4374: ,0)) sum_totals*/
4375: FROM pay_assignment_actions paa
4376: ,pay_action_information le_lu
4377: ,pay_action_information asg_act
4378: ,pay_action_information rep_cde
4379: ,pay_action_information cde_dtl

Line 4420: FROM pay_assignment_actions paa

4416: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4417: , 0)) bl_earnings
4418: ,*/
4419: SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4420: FROM pay_assignment_actions paa
4421: ,pay_action_information le_lu
4422: ,pay_action_information asg_act
4423: ,pay_action_information rep_cde
4424: ,pay_action_information cde_dtl

Line 4462: FROM pay_assignment_actions paa

4458: SELECT asg_act.action_information2 legal_employer_id
4459: ,le_lu.action_information3 si_status
4460: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
4461: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4462: FROM pay_assignment_actions paa
4463: ,pay_action_information le_lu
4464: ,pay_action_information asg_act
4465: ,pay_action_information rep_cde
4466: ,pay_action_information cde_dtl

Line 5384: FROM pay_assignment_actions paa

5380: ,0)) sum_zone5
5381: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5382: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
5383: ,0)) sum_totals
5384: FROM pay_assignment_actions paa
5385: ,pay_action_information le_lu
5386: ,pay_action_information asg_act
5387: ,pay_action_information rep_cde
5388: ,pay_action_information cde_dtl

Line 5427: FROM pay_assignment_actions paa

5423: ,SUM(DECODE(asg_act.action_information7
5424: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
5425: , 0)) bl_earnings
5426: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
5427: FROM pay_assignment_actions paa
5428: ,pay_action_information le_lu
5429: ,pay_action_information asg_act
5430: ,pay_action_information rep_cde
5431: ,pay_action_information cde_dtl

Line 5468: FROM pay_assignment_actions paa

5464: SELECT asg_act.action_information2 legal_employer_id
5465: ,le_lu.action_information3 si_status
5466: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
5467: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
5468: FROM pay_assignment_actions paa
5469: ,pay_action_information le_lu
5470: ,pay_action_information asg_act
5471: ,pay_action_information rep_cde
5472: ,pay_action_information cde_dtl