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_PAYROLL_ACTIONS

Line 31: FROM pay_payroll_actions

27: ,get_parameters(c_payroll_action_id, 'Sequence_Number')
28: ,start_date
29: ,effective_date
30: ,business_group_id
31: FROM pay_payroll_actions
32: WHERE payroll_action_id = c_payroll_action_id;
33: --
34: BEGIN
35: --

Line 60: FROM pay_payroll_actions

56: SELECT SUBSTR(legislative_parameters,
57: INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1),
58: INSTR(legislative_parameters,' ',INSTR(legislative_parameters,p_token_name))
59: -(INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1)))
60: FROM pay_payroll_actions
61: WHERE payroll_action_id = p_payroll_action_id;
62: --
63: l_token_value VARCHAR2(50);
64: --

Line 87: 'pay_payroll_actions ppa '||

83: -- the string, and the statement must be ordered by person_id
84: --
85: sqlstr := 'select distinct person_id '||
86: 'from per_people_f ppf, '||
87: 'pay_payroll_actions ppa '||
88: 'where ppa.payroll_action_id = :payroll_action_id '||
89: 'and ppa.business_group_id = ppf.business_group_id '||
90: 'order by ppf.person_id';
91: --

Line 2289: -- ,pay_payroll_actions bact

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
2293: ,pay_run_results adj_prr

Line 2291: -- ,pay_payroll_actions pact

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
2295: --and bal_assact.payroll_action_id = bact.payroll_action_id

Line 2948: ,pay_payroll_actions ppa

2944: ,action_information8
2945: ,sum(fnd_number.canonical_to_number(action_information9)) action_information9
2946: ,sum(fnd_number.canonical_to_number(action_information10))action_information10
2947: FROM pay_action_information pai
2948: ,pay_payroll_actions ppa
2949: WHERE ppa.report_type = 'NL_WAGES_REP_ARCHIVE'
2950: AND ppa.report_qualifier = 'NL'
2951: AND ppa.action_type = 'X'
2952: AND ppa.action_status = 'C'

Line 2973: ,pay_payroll_actions ppa

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
2977: AND pai.locking_action_id = paa.assignment_action_id;

Line 2984: ,pay_payroll_actions ppa

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
2988: ,pay_payroll_actions ppa2

Line 2988: ,pay_payroll_actions ppa2

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
2992: AND paa1.assignment_action_id = pai.locked_action_id

Line 3003: ,pay_payroll_actions ppa1

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
3007: ,per_time_periods ptp2

Line 3005: ,pay_payroll_actions ppa2

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
3009: ,pay_all_payrolls_f ppf2

Line 4299: ,pay_payroll_actions ppa

4295: SELECT asl.assignment_id assignment_id
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

Line 4396: FROM pay_payroll_actions ppa

4392: ,paa.assignment_id
4393: ,paaf.person_id
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'

Line 4397: ,pay_payroll_actions ppa1

4393: ,paaf.person_id
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'

Line 4441: ,pay_payroll_actions ppa

4437: ,c_paid_flag VARCHAR2) IS
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

Line 4596: ,pay_payroll_actions ppa

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
4599: AND paaf.person_id BETWEEN stperson
4600: AND endperson

Line 5995: ,pay_payroll_actions ppa

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
5999: WHERE paa.assignment_id = c_assignment_id

Line 5998: ,pay_payroll_actions ppl

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'
6002: AND ppa.report_qualifier = 'NL'

Line 6044: ,pay_payroll_actions ppa

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
6048: AND pee.creator_type IN ('RR','EE')

Line 6101: ,pay_payroll_actions ppa

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
6105: AND rr1.element_entry_id = pee1.element_entry_id

Line 6136: ,pay_payroll_actions ppa

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
6140: AND ppa.action_type IN ('R','Q')

Line 6151: ,pay_payroll_actions ppa

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
6155: AND ppa.action_type IN ('R','Q','I','B')

Line 8427: ,pay_payroll_actions ppa

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
8431: AND ppa.action_type IN ('R','Q')

Line 8443: ,pay_payroll_actions ppa

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
8447: AND ppa.action_type IN ('R','Q','I','B')