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

Line 1094: FROM pay_assignment_actions paa

1090: CURSOR csr_chk_corr_ele_exists(c_pay_act_id NUMBER) IS
1091: SELECT 'Y'
1092: FROM DUAL
1093: WHERE EXISTS (SELECT /*+ ORDERED */ 1
1094: FROM pay_assignment_actions paa
1095: ,pay_action_information pai
1096: WHERE paa.payroll_action_id = c_pay_act_id
1097: AND pai.action_context_id = paa.assignment_action_id
1098: AND pai.action_context_type = 'AAP'

Line 2288: FROM pay_assignment_actions bal_assact

2284: CURSOR csr_chk_corr_ele_exists(c_ass_act_id NUMBER) IS
2285: SELECT 'Y'
2286: FROM DUAL
2287: WHERE EXISTS (SELECT /*+ ORDERED */ 1
2288: FROM pay_assignment_actions bal_assact
2289: -- ,pay_payroll_actions bact
2290: ,pay_assignment_actions assact
2291: -- ,pay_payroll_actions pact
2292: ,pay_element_types_f adj_petf

Line 2290: ,pay_assignment_actions assact

2286: FROM DUAL
2287: WHERE EXISTS (SELECT /*+ ORDERED */ 1
2288: FROM pay_assignment_actions bal_assact
2289: -- ,pay_payroll_actions bact
2290: ,pay_assignment_actions assact
2291: -- ,pay_payroll_actions pact
2292: ,pay_element_types_f adj_petf
2293: ,pay_run_results adj_prr
2294: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id

Line 2791: FROM pay_assignment_actions paa

2787: -- cursor to get distinct start date and end date for the records archived
2788: CURSOR csr_period_dates(c_pact_id NUMBER) IS
2789: SELECT DISTINCT pai.Action_Information2 Start_date
2790: ,pai.action_information3 End_date
2791: FROM pay_assignment_actions paa
2792: ,pay_action_information pai
2793: WHERE paa.payroll_action_id = c_pact_id
2794: AND paa.assignment_action_id = pai.action_context_id
2795: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'

Line 2835: FROM pay_assignment_actions paa

2831: -- Correction balance total periods
2832: CURSOR csr_ret_cor_period(c_pact_id NUMBER) IS
2833: SELECT DISTINCT fnd_date.canonical_to_date(pai.Action_Information2) Start_date
2834: ,fnd_date.canonical_to_date(pai.action_information3) End_date
2835: FROM pay_assignment_actions paa
2836: ,pay_action_information pai
2837: WHERE paa.payroll_action_id = c_pact_id
2838: AND paa.assignment_action_id = pai.action_context_id
2839: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'

Line 2905: FROM pay_assignment_actions paa

2901: ,pai_p.action_information6 Description
2902: ,substr(pai_p.action_information7,1,30) E_Name
2903: ,substr(pai_p.action_information8,1,30) E_Number
2904: ,pai_p.action_context_type cxt
2905: FROM pay_assignment_actions paa
2906: ,pay_action_information pai_p
2907: WHERE paa.payroll_action_id = p_payroll_action_id
2908: AND pai_p.action_context_id = paa.assignment_action_id
2909: AND pai_p.action_information_category = 'NL_WR_EXCEPTION_REPORT'

Line 2924: FROM pay_assignment_actions paa

2920: --#
2921: --
2922: CURSOR csr_get_pactid IS
2923: SELECT DISTINCT paa1.payroll_action_id
2924: FROM pay_assignment_actions paa
2925: ,pay_action_interlocks pal
2926: ,pay_assignment_actions paa1
2927: WHERE paa.payroll_action_id = p_actid
2928: AND paa.assignment_action_id = pal.locking_action_id

Line 2926: ,pay_assignment_actions paa1

2922: CURSOR csr_get_pactid IS
2923: SELECT DISTINCT paa1.payroll_action_id
2924: FROM pay_assignment_actions paa
2925: ,pay_action_interlocks pal
2926: ,pay_assignment_actions paa1
2927: WHERE paa.payroll_action_id = p_actid
2928: AND paa.assignment_action_id = pal.locking_action_id
2929: AND pal.locked_action_id = paa1.assignment_action_id
2930: ORDER BY paa1.payroll_action_id DESC;

Line 2961: FROM pay_assignment_actions paa1

2957: AND pai.action_context_type = 'PA'
2958: AND pai.action_context_id = ppa.payroll_action_id
2959: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'
2960: AND EXISTS ( SELECT 1
2961: FROM pay_assignment_actions paa1
2962: ,pay_action_interlocks ai
2963: ,pay_assignment_actions paa2
2964: WHERE paa1.payroll_action_id = p_actid
2965: AND paa1.assignment_action_id = ai.locking_action_id

Line 2963: ,pay_assignment_actions paa2

2959: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'
2960: AND EXISTS ( SELECT 1
2961: FROM pay_assignment_actions paa1
2962: ,pay_action_interlocks ai
2963: ,pay_assignment_actions paa2
2964: WHERE paa1.payroll_action_id = p_actid
2965: AND paa1.assignment_action_id = ai.locking_action_id
2966: AND ai.locked_action_id = paa2.assignment_action_id
2967: AND paa2.payroll_action_id = ppa.payroll_action_id)

Line 2972: FROM pay_assignment_actions paa

2968: GROUP BY action_information7,action_information8;
2969: --
2970: CURSOR csr_payroll_get_action_id(c_payroll_action_id NUMBER) IS
2971: SELECT max(locked_action_id)
2972: FROM pay_assignment_actions paa
2973: ,pay_payroll_actions ppa
2974: ,pay_action_interlocks pai
2975: WHERE ppa.payroll_action_id = c_payroll_action_id
2976: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2983: FROM pay_assignment_actions paa

2979: CURSOR csr_payroll_get_action_id2(c_payroll_action_id NUMBER
2980: ,c_start_date DATE
2981: ,c_end_date DATE) IS
2982: SELECT max(paa2.assignment_action_id)
2983: FROM pay_assignment_actions paa
2984: ,pay_payroll_actions ppa
2985: ,pay_action_interlocks pai
2986: ,pay_assignment_actions paa1
2987: ,pay_assignment_actions paa2

Line 2986: ,pay_assignment_actions paa1

2982: SELECT max(paa2.assignment_action_id)
2983: FROM pay_assignment_actions paa
2984: ,pay_payroll_actions ppa
2985: ,pay_action_interlocks pai
2986: ,pay_assignment_actions paa1
2987: ,pay_assignment_actions paa2
2988: ,pay_payroll_actions ppa2
2989: WHERE ppa.payroll_action_id = c_payroll_action_id
2990: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2987: ,pay_assignment_actions paa2

2983: FROM pay_assignment_actions paa
2984: ,pay_payroll_actions ppa
2985: ,pay_action_interlocks pai
2986: ,pay_assignment_actions paa1
2987: ,pay_assignment_actions paa2
2988: ,pay_payroll_actions ppa2
2989: WHERE ppa.payroll_action_id = c_payroll_action_id
2990: AND paa.payroll_action_id = ppa.payroll_action_id
2991: AND pai.locking_action_id = paa.assignment_action_id

Line 3002: FROM pay_assignment_actions paa1

2998: AND ppa2.action_status = 'C';
2999: --
3000: CURSOR csr_get_prev_period(c_ass_act_id NUMBER) IS
3001: SELECT paa2.assignment_action_id, ptp2.end_date
3002: FROM pay_assignment_actions paa1
3003: ,pay_payroll_actions ppa1
3004: ,pay_assignment_actions paa2
3005: ,pay_payroll_actions ppa2
3006: ,per_time_periods ptp1

Line 3004: ,pay_assignment_actions paa2

3000: CURSOR csr_get_prev_period(c_ass_act_id NUMBER) IS
3001: SELECT paa2.assignment_action_id, ptp2.end_date
3002: FROM pay_assignment_actions paa1
3003: ,pay_payroll_actions ppa1
3004: ,pay_assignment_actions paa2
3005: ,pay_payroll_actions ppa2
3006: ,per_time_periods ptp1
3007: ,per_time_periods ptp2
3008: ,pay_all_payrolls_f ppf1

Line 4300: ,pay_assignment_actions paa

4296: ,paa.assignment_action_id assignment_action_id
4297: FROM per_all_assignments_f asl
4298: ,pay_all_payrolls_f ppf
4299: ,pay_payroll_actions ppa
4300: ,pay_assignment_actions paa
4301: ,per_time_periods ptp
4302: WHERE asl.person_id BETWEEN stperson AND endperson and
4303: ppf.payroll_id = asl.payroll_id
4304: AND ((ppf.period_type = 'Calendar Month'

Line 4325: FROM pay_assignment_actions paa1

4321: AND ppf.effective_end_date
4322: AND asl.business_group_id = ppa.business_group_id
4323: AND ppa.business_group_id = c_business_group_id
4324: AND (EXISTS (SELECT 1
4325: FROM pay_assignment_actions paa1
4326: ,pay_run_results prr
4327: WHERE paa1.source_action_id = paa.assignment_action_id
4328: AND prr.assignment_action_id = paa1.assignment_action_id))
4329: UNION

Line 4398: ,pay_assignment_actions paa

4394: ,ppa1.effective_date
4395: ,paaf.primary_flag
4396: FROM pay_payroll_actions ppa
4397: ,pay_payroll_actions ppa1
4398: ,pay_assignment_actions paa
4399: ,per_all_assignments_f paaf
4400: WHERE ppa.report_type = 'NL_WAGES_REP_LOCK'
4401: AND ppa.report_qualifier = 'NL'
4402: AND ppa.action_type = 'X'

Line 4442: ,pay_assignment_actions paa

4438: SELECT DISTINCT asl.assignment_id assignment_id
4439: ,paa.assignment_action_id assignment_action_id
4440: FROM per_all_assignments_f asl
4441: ,pay_payroll_actions ppa
4442: ,pay_assignment_actions paa
4443: ,per_time_periods ptp
4444: WHERE asl.person_id BETWEEN stperson AND endperson and
4445: ppa.payroll_id = asl.payroll_id
4446: AND ppa.action_type in ('R','Q')

Line 4459: FROM pay_assignment_actions paa1

4455: AND asl.effective_end_date >= c_start_date
4456: AND asl.business_group_id = ppa.business_group_id
4457: AND ppa.business_group_id = c_business_group_id
4458: AND (EXISTS (SELECT 1
4459: FROM pay_assignment_actions paa1
4460: ,pay_run_results prr
4461: WHERE paa1.source_action_id = paa.assignment_action_id
4462: AND prr.assignment_action_id = paa1.assignment_action_id))
4463: UNION

Line 4523: SELECT pay_assignment_actions_s.NEXTVAL

4519: IF csr_persons_rec.person_id <> l_chk_person_id THEN
4520: --
4521: l_chk_person_id := csr_persons_rec.person_id;
4522: --
4523: SELECT pay_assignment_actions_s.NEXTVAL
4524: INTO l_actid
4525: FROM dual;
4526: -- CREATE THE ARCHIVE ASSIGNMENT ACTION
4527: hr_nonrun_asact.insact(lockingactid => l_actid

Line 4542: SELECT pay_assignment_actions_s.NEXTVAL

4538: l_chk_assignment_id := 0;
4539: FOR csr_rec IN csr_assignments_yearly(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
4540: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
4541: l_chk_assignment_id := csr_rec.assignment_id;
4542: SELECT pay_assignment_actions_s.NEXTVAL
4543: INTO l_actid
4544: FROM dual;
4545: --Fnd_file.put_line(FND_FILE.LOG,'#######~~csr_rec.assignment_action_id :'||l_actid||','||csr_rec.assignment_action_id);
4546: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 4565: SELECT pay_assignment_actions_s.NEXTVAL

4561: --
4562: FOR csr_rec IN csr_assignments(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
4563: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
4564: l_chk_assignment_id := csr_rec.assignment_id;
4565: SELECT pay_assignment_actions_s.NEXTVAL
4566: INTO l_actid
4567: FROM dual;
4568: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
4569: hr_nonrun_asact.insact(lockingactid => l_actid

Line 4594: FROM pay_assignment_actions paa

4590: --
4591: CURSOR csr_assignment_actions(p_arc_pactid NUMBER) IS
4592: SELECT paa.assignment_action_id
4593: ,paa.assignment_id
4594: FROM pay_assignment_actions paa
4595: ,per_all_assignments_f paaf
4596: ,pay_payroll_actions ppa
4597: WHERE paa.payroll_action_id = p_arc_pactid
4598: AND paa.payroll_action_id = ppa.payroll_action_id

Line 4617: SELECT pay_assignment_actions_s.NEXTVAL

4613: l_arc_pactid := TO_NUMBER(get_parameters(p_actid,'REQUEST_ID'));
4614: --
4615: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP
4616: --
4617: SELECT pay_assignment_actions_s.NEXTVAL
4618: INTO l_actid
4619: FROM dual;
4620: --
4621: hr_nonrun_asact.insact(lockingactid => l_actid

Line 5994: FROM pay_assignment_actions paa

5990: CURSOR csr_chk_emp_reported(c_assignment_id NUMBER) IS
5991: SELECT 'Y'
5992: FROM DUAL
5993: WHERE EXISTS(SELECT /*+ ORDERED */ 1
5994: FROM pay_assignment_actions paa
5995: ,pay_payroll_actions ppa
5996: ,pay_action_interlocks pai
5997: ,pay_assignment_actions pal
5998: ,pay_payroll_actions ppl

Line 5997: ,pay_assignment_actions pal

5993: WHERE EXISTS(SELECT /*+ ORDERED */ 1
5994: FROM pay_assignment_actions paa
5995: ,pay_payroll_actions ppa
5996: ,pay_action_interlocks pai
5997: ,pay_assignment_actions pal
5998: ,pay_payroll_actions ppl
5999: WHERE paa.assignment_id = c_assignment_id
6000: AND paa.payroll_action_id = ppa.payroll_action_id
6001: AND ppa.report_type = 'NL_WAGES_REP_ARCHIVE'

Line 6043: ,pay_assignment_actions paa

6039: SELECT DISTINCT ptp.start_date start_date
6040: ,ptp.end_date end_date
6041: FROM pay_run_results prr
6042: ,pay_element_entries_f pee
6043: ,pay_assignment_actions paa
6044: ,pay_payroll_actions ppa
6045: ,per_time_periods ptp
6046: WHERE prr.assignment_action_id = paa.assignment_action_id
6047: AND prr.element_type_id = pee.element_type_id

Line 6100: ,pay_assignment_actions paa

6096: ,pay_element_span_usages esu
6097: ,pay_retro_component_usages rcu
6098: ,pay_retro_components rc
6099: ,pay_element_entries_f pee1
6100: ,pay_assignment_actions paa
6101: ,pay_payroll_actions ppa
6102: ,per_time_periods ptp
6103: WHERE paa.assignment_action_id = c_assignment_action_id
6104: AND rr1.assignment_action_id = paa.assignment_action_id

Line 6135: FROM pay_assignment_actions paa

6131: --
6132: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
6133: ,c_date DATE) IS
6134: SELECT max(paa.assignment_action_id) assignment_action_id
6135: FROM pay_assignment_actions paa
6136: ,pay_payroll_actions ppa
6137: ,per_time_periods ptp
6138: WHERE paa.assignment_id = c_assignment_id
6139: AND ppa.payroll_action_id = paa.payroll_action_id

Line 6150: FROM pay_assignment_actions paa

6146: --
6147: CURSOR csr_get_assignment_action_id2(c_assignment_id NUMBER
6148: ,c_date DATE) IS
6149: SELECT max(paa.assignment_action_id) assignment_action_id
6150: FROM pay_assignment_actions paa
6151: ,pay_payroll_actions ppa
6152: ,per_time_periods ptp
6153: WHERE paa.assignment_id = c_assignment_id
6154: AND ppa.payroll_action_id = paa.payroll_action_id

Line 8426: FROM pay_assignment_actions paa

8422: --
8423: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
8424: ,c_date DATE) IS
8425: SELECT max(paa.assignment_action_id) assignment_action_id
8426: FROM pay_assignment_actions paa
8427: ,pay_payroll_actions ppa
8428: ,per_time_periods ptp
8429: WHERE paa.assignment_id = c_assignment_id
8430: AND ppa.payroll_action_id = paa.payroll_action_id

Line 8442: FROM pay_assignment_actions paa

8438: CURSOR csr_get_assignment_action_id2(c_assignment_id NUMBER
8439: ,c_date DATE
8440: ,c_end_date DATE) IS
8441: SELECT max(paa.assignment_action_id) assignment_action_id
8442: FROM pay_assignment_actions paa
8443: ,pay_payroll_actions ppa
8444: ,per_time_periods ptp
8445: WHERE paa.assignment_id = c_assignment_id
8446: AND ppa.payroll_action_id = paa.payroll_action_id

Line 8932: from pay_assignment_actions

8928: --
8929: --Fnd_file.put_line(FND_FILE.LOG,' Entering Archive Code for Assignment :'||p_assactid);
8930: select payroll_action_id,assignment_id
8931: into l_pactid, l_assignment_id
8932: from pay_assignment_actions
8933: where assignment_action_id = p_assactid;
8934: --
8935: get_all_parameters (l_pactid
8936: ,l_business_group_id

Line 8978: FROM pay_assignment_actions paa

8974: FROM pay_action_information pai
8975: WHERE action_context_id = c_payroll_action_id
8976: AND action_information_category = 'NL_WR_EXCEPTION_REPORT')
8977: OR EXISTS (SELECT 1
8978: FROM pay_assignment_actions paa
8979: ,pay_action_information pai
8980: WHERE paa.payroll_action_id = c_payroll_action_id
8981: AND pai.action_context_id = paa.assignment_action_id
8982: AND pai.action_information_category = 'NL_WR_EXCEPTION_REPORT');