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 81: FROM pay_payroll_actions

77: ,business_group_id
78: --,NVL(to_char(fnd_date.canonical_to_date(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR')),'RRRR'),-9999) --10100628
79: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'CORR_YR'),'N') --10100628
80: ,NVL(pay_nl_wage_report_pkg.get_parameters(c_payroll_action_id, 'ER_ONLY'),'N') --10100628
81: FROM pay_payroll_actions
82: WHERE payroll_action_id = c_payroll_action_id;
83: --
84: BEGIN
85: --

Line 121: FROM pay_payroll_actions

117: SELECT SUBSTR(legislative_parameters,
118: INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1),
119: INSTR(legislative_parameters,' ',INSTR(legislative_parameters,p_token_name))
120: -(INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1)))
121: FROM pay_payroll_actions
122: WHERE payroll_action_id = p_payroll_action_id;
123: --
124: l_token_value VARCHAR2(50);
125: --

Line 143: FROM pay_payroll_actions

139: SELECT SUBSTR(legislative_parameters,
140: INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1),
141: INSTR(legislative_parameters,' ',INSTR(legislative_parameters,p_token_name))
142: -(INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1)))
143: FROM pay_payroll_actions
144: WHERE payroll_action_id = p_payroll_action_id;
145: --
146: l_token_value VARCHAR2(50);
147: --

Line 174: 'pay_payroll_actions ppa '||

170: -- the string, and the statement must be ordered by person_id
171: --
172: sqlstr := 'select distinct person_id '||
173: 'from per_people_f ppf, '||
174: 'pay_payroll_actions ppa '||
175: 'where ppa.payroll_action_id = :payroll_action_id '||
176: 'and ppa.business_group_id = ppf.business_group_id '||
177: 'order by ppf.person_id';
178: --

Line 2344: FROM pay_payroll_actions

2340: SELECT get_parameters (c_payroll_action_id
2341: ,'Sequence_Number') seq_no
2342: ,start_date
2343: ,business_group_id
2344: FROM pay_payroll_actions
2345: WHERE payroll_action_id = c_payroll_action_id;
2346: ----
2347: CURSOR csr_get_no_pay_period(c_payroll_type VARCHAR2) IS
2348: SELECT number_per_fiscal_year

Line 2368: ,pay_payroll_actions generator

2364: ,min (fnd_date.canonical_to_date (info.action_information3)) startdate
2365: ,max (fnd_date.canonical_to_date (info.action_information4)) enddate
2366: ,count (DISTINCT generator.request_id) wagereports
2367: FROM pay_action_information info
2368: ,pay_payroll_actions generator
2369: ,pay_payroll_actions datalock
2370: WHERE info.action_context_id = generator.payroll_action_id
2371: AND info.action_information2 IN ('TotLnLbPh','EhOvsFrfWrkkstrg')
2372: AND datalock.report_type = 'NL_WAGES_REP_LOCK'

Line 2369: ,pay_payroll_actions datalock

2365: ,max (fnd_date.canonical_to_date (info.action_information4)) enddate
2366: ,count (DISTINCT generator.request_id) wagereports
2367: FROM pay_action_information info
2368: ,pay_payroll_actions generator
2369: ,pay_payroll_actions datalock
2370: WHERE info.action_context_id = generator.payroll_action_id
2371: AND info.action_information2 IN ('TotLnLbPh','EhOvsFrfWrkkstrg')
2372: AND datalock.report_type = 'NL_WAGES_REP_LOCK'
2373: AND datalock.business_group_id = c_bg_id

Line 3458: -- ,pay_payroll_actions bact

3454: SELECT 'Y'
3455: FROM DUAL
3456: WHERE EXISTS (SELECT /*+ ORDERED */ 1
3457: FROM pay_assignment_actions bal_assact
3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
3460: -- ,pay_payroll_actions pact
3461: ,pay_element_types_f adj_petf
3462: ,pay_run_results adj_prr

Line 3460: -- ,pay_payroll_actions pact

3456: WHERE EXISTS (SELECT /*+ ORDERED */ 1
3457: FROM pay_assignment_actions bal_assact
3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
3460: -- ,pay_payroll_actions pact
3461: ,pay_element_types_f adj_petf
3462: ,pay_run_results adj_prr
3463: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id
3464: --and bal_assact.payroll_action_id = bact.payroll_action_id

Line 4466: ,pay_payroll_actions ppa

4462: ,action_information8
4463: ,sum(fnd_number.canonical_to_number(action_information9)) action_information9
4464: ,sum(fnd_number.canonical_to_number(action_information10))action_information10
4465: FROM pay_action_information pai
4466: ,pay_payroll_actions ppa
4467: WHERE ppa.report_type = 'NL_WAGES_REP_ARCHIVE'
4468: AND ppa.report_qualifier = 'NL'
4469: AND ppa.action_type = 'X'
4470: AND ppa.action_status = 'C'

Line 4491: ,pay_payroll_actions ppa

4487: --
4488: CURSOR csr_payroll_get_action_id(c_payroll_action_id NUMBER) IS
4489: SELECT max(locked_action_id)
4490: FROM pay_assignment_actions paa
4491: ,pay_payroll_actions ppa
4492: ,pay_action_interlocks pai
4493: WHERE ppa.payroll_action_id = c_payroll_action_id
4494: AND paa.payroll_action_id = ppa.payroll_action_id
4495: AND pai.locking_action_id = paa.assignment_action_id;

Line 4502: ,pay_payroll_actions ppa

4498: ,c_start_date DATE
4499: ,c_end_date DATE) IS
4500: SELECT max(paa2.assignment_action_id)
4501: FROM pay_assignment_actions paa
4502: ,pay_payroll_actions ppa
4503: ,pay_action_interlocks pai
4504: ,pay_assignment_actions paa1
4505: ,pay_assignment_actions paa2
4506: ,pay_payroll_actions ppa2

Line 4506: ,pay_payroll_actions ppa2

4502: ,pay_payroll_actions ppa
4503: ,pay_action_interlocks pai
4504: ,pay_assignment_actions paa1
4505: ,pay_assignment_actions paa2
4506: ,pay_payroll_actions ppa2
4507: WHERE ppa.payroll_action_id = c_payroll_action_id
4508: AND paa.payroll_action_id = ppa.payroll_action_id
4509: AND pai.locking_action_id = paa.assignment_action_id
4510: AND paa1.assignment_action_id = pai.locked_action_id

Line 4521: ,pay_payroll_actions ppa1

4517: --
4518: CURSOR csr_get_prev_period(c_ass_act_id NUMBER) IS
4519: SELECT paa2.assignment_action_id, ptp2.end_date
4520: FROM pay_assignment_actions paa1
4521: ,pay_payroll_actions ppa1
4522: ,pay_assignment_actions paa2
4523: ,pay_payroll_actions ppa2
4524: ,per_time_periods ptp1
4525: ,per_time_periods ptp2

Line 4523: ,pay_payroll_actions ppa2

4519: SELECT paa2.assignment_action_id, ptp2.end_date
4520: FROM pay_assignment_actions paa1
4521: ,pay_payroll_actions ppa1
4522: ,pay_assignment_actions paa2
4523: ,pay_payroll_actions ppa2
4524: ,per_time_periods ptp1
4525: ,per_time_periods ptp2
4526: ,pay_all_payrolls_f ppf1
4527: ,pay_all_payrolls_f ppf2

Line 4670: pay_payroll_actions ppa,

4666: CURSOR C_ASG_ACT_ID(p_bg_id NUMBER, p_tax_unit_id NUMBER, p_pd_start_date DATE, p_pd_end_date DATE)
4667: IS
4668: select max(paa.assignment_action_id)
4669: from
4670: pay_payroll_actions ppa,
4671: pay_assignment_actions paa,
4672: pay_payrolls_f ppf
4673: where
4674: ppa.payroll_action_id = paa.payroll_action_id

Line 7187: ,pay_payroll_actions ppa

7183: SELECT asl.assignment_id assignment_id
7184: ,paa.assignment_action_id assignment_action_id
7185: FROM per_all_assignments_f asl
7186: ,pay_all_payrolls_f ppf
7187: ,pay_payroll_actions ppa
7188: ,pay_assignment_actions paa
7189: ,per_time_periods ptp
7190: WHERE asl.person_id BETWEEN stperson AND endperson and
7191: ppf.payroll_id = asl.payroll_id

Line 7284: FROM pay_payroll_actions ppa

7280: ,paa.assignment_id
7281: ,paaf.person_id
7282: ,ppa1.effective_date
7283: ,paaf.primary_flag
7284: FROM pay_payroll_actions ppa
7285: ,pay_payroll_actions ppa1
7286: ,pay_assignment_actions paa
7287: ,per_all_assignments_f paaf
7288: WHERE ppa.report_type = 'NL_WAGES_REP_LOCK'

Line 7285: ,pay_payroll_actions ppa1

7281: ,paaf.person_id
7282: ,ppa1.effective_date
7283: ,paaf.primary_flag
7284: FROM pay_payroll_actions ppa
7285: ,pay_payroll_actions ppa1
7286: ,pay_assignment_actions paa
7287: ,per_all_assignments_f paaf
7288: WHERE ppa.report_type = 'NL_WAGES_REP_LOCK'
7289: AND ppa.report_qualifier = 'NL'

Line 7329: ,pay_payroll_actions ppa

7325: ,c_paid_flag VARCHAR2) IS
7326: SELECT DISTINCT asl.assignment_id assignment_id
7327: ,paa.assignment_action_id assignment_action_id
7328: FROM per_all_assignments_f asl
7329: ,pay_payroll_actions ppa
7330: ,pay_assignment_actions paa
7331: ,per_time_periods ptp
7332: WHERE asl.person_id BETWEEN stperson AND endperson and
7333: ppa.payroll_id = asl.payroll_id

Line 7387: ,pay_payroll_actions ppa

7383: SELECT asl.assignment_id assignment_id
7384: ,paa.assignment_action_id assignment_action_id
7385: FROM per_all_assignments_f asl
7386: ,pay_all_payrolls_f ppf
7387: ,pay_payroll_actions ppa
7388: ,pay_assignment_actions paa
7389: ,per_time_periods ptp
7390: WHERE asl.person_id between stperson AND endperson and
7391: ppf.payroll_id = asl.payroll_id

Line 7437: ,pay_payroll_actions ppa1

7433: ,pay_retro_component_usages rcu
7434: ,pay_retro_components rc
7435: ,pay_element_entries_f pee1
7436: ,pay_assignment_actions paa1
7437: ,pay_payroll_actions ppa1
7438: ,per_time_periods ptp
7439: WHERE paa1.source_action_id = paa.assignment_action_id
7440: --AND paa1.assignment_action_id = paa.assignment_action_id
7441: AND rr1.assignment_action_id = paa1.assignment_action_id

Line 7623: ,pay_payroll_actions ppa

7619: SELECT paa.assignment_action_id
7620: ,paa.assignment_id
7621: FROM pay_assignment_actions paa
7622: ,per_all_assignments_f paaf
7623: ,pay_payroll_actions ppa
7624: WHERE paa.payroll_action_id = p_arc_pactid
7625: AND paa.payroll_action_id = ppa.payroll_action_id
7626: AND paaf.person_id BETWEEN stperson
7627: AND endperson

Line 9663: ,pay_payroll_actions ppa

9659: SELECT 'Y'
9660: FROM DUAL
9661: WHERE EXISTS(SELECT /*+ ORDERED */ 1
9662: FROM pay_assignment_actions paa
9663: ,pay_payroll_actions ppa
9664: ,pay_action_interlocks pai
9665: ,pay_assignment_actions pal
9666: ,pay_payroll_actions ppl
9667: WHERE paa.assignment_id = c_assignment_id

Line 9666: ,pay_payroll_actions ppl

9662: FROM pay_assignment_actions paa
9663: ,pay_payroll_actions ppa
9664: ,pay_action_interlocks pai
9665: ,pay_assignment_actions pal
9666: ,pay_payroll_actions ppl
9667: WHERE paa.assignment_id = c_assignment_id
9668: AND paa.payroll_action_id = ppa.payroll_action_id
9669: AND ppa.report_type = 'NL_WAGES_REP_ARCHIVE'
9670: AND ppa.report_qualifier = 'NL'

Line 9712: ,pay_payroll_actions ppa

9708: ,ptp.end_date end_date
9709: FROM pay_run_results prr
9710: ,pay_element_entries_f pee
9711: ,pay_assignment_actions paa
9712: ,pay_payroll_actions ppa
9713: ,per_time_periods ptp
9714: WHERE prr.assignment_action_id = paa.assignment_action_id
9715: AND prr.element_type_id = pee.element_type_id
9716: AND pee.creator_type IN ('RR','EE')

Line 9769: ,pay_payroll_actions ppa

9765: ,pay_retro_component_usages rcu
9766: ,pay_retro_components rc
9767: ,pay_element_entries_f pee1
9768: ,pay_assignment_actions paa
9769: ,pay_payroll_actions ppa
9770: ,per_time_periods ptp
9771: WHERE paa.assignment_action_id = c_assignment_action_id
9772: AND rr1.assignment_action_id = paa.assignment_action_id
9773: AND rr1.element_entry_id = pee1.element_entry_id

Line 9804: ,pay_payroll_actions ppa

9800: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
9801: ,c_date DATE) IS
9802: SELECT max(paa.assignment_action_id) assignment_action_id
9803: FROM pay_assignment_actions paa
9804: ,pay_payroll_actions ppa
9805: ,per_time_periods ptp
9806: WHERE paa.assignment_id = c_assignment_id
9807: AND ppa.payroll_action_id = paa.payroll_action_id
9808: AND ppa.action_type IN ('R','Q')

Line 9820: ,pay_payroll_actions ppa

9816: ,c_date DATE) IS
9817: SELECT --max(paa.assignment_action_id) assignment_action_id --11731857
9818: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) assignment_action_id --11731857
9819: FROM pay_assignment_actions paa
9820: ,pay_payroll_actions ppa
9821: ,per_time_periods ptp
9822: WHERE paa.assignment_id = c_assignment_id
9823: AND ppa.payroll_action_id = paa.payroll_action_id
9824: AND ppa.action_type IN ('R','Q','I','B')

Line 9989: ,pay_payroll_actions ppa

9985: SELECT distinct asl.assignment_id assignment_id
9986: FROM per_all_assignments_f asl
9987: ,per_all_assignments_f asl2
9988: ,pay_all_payrolls_f ppf
9989: ,pay_payroll_actions ppa
9990: ,pay_assignment_actions paa
9991: ,per_time_periods ptp
9992: WHERE asl.person_id = asl2.person_id
9993: AND asl2.assignment_id = c_assg_id

Line 10130: pay_payroll_actions ppa,

10126: CURSOR c_corr_pd_prev_yrs(p_asg_id NUMBER, p_start_date DATE, p_end_date DATE)
10127: IS
10128: select distinct ptp.start_date, ptp.end_date
10129: from
10130: pay_payroll_actions ppa,
10131: pay_assignment_actions paa,
10132: per_time_periods ptp
10133: where
10134: ppa.action_type in ('R', 'Q')

Line 14016: ,pay_payroll_actions ppa

14012: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
14013: ,c_date DATE) IS
14014: SELECT max(paa.assignment_action_id) assignment_action_id
14015: FROM pay_assignment_actions paa
14016: ,pay_payroll_actions ppa
14017: ,per_time_periods ptp
14018: WHERE paa.assignment_id = c_assignment_id
14019: AND ppa.payroll_action_id = paa.payroll_action_id
14020: AND ppa.action_type IN ('R','Q')

Line 14033: ,pay_payroll_actions ppa

14029: ,c_end_date DATE) IS
14030: SELECT --max(paa.assignment_action_id) assignment_action_id
14031: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) assignment_action_id --11731857
14032: FROM pay_assignment_actions paa
14033: ,pay_payroll_actions ppa
14034: ,per_time_periods ptp
14035: WHERE paa.assignment_id = c_assignment_id
14036: AND ppa.payroll_action_id = paa.payroll_action_id
14037: AND ppa.action_type IN ('R','Q','I','B')

Line 14186: ,pay_payroll_actions ppa

14182: ,c_tax_unit_id NUMBER) IS
14183: SELECT distinct asl.assignment_id assignment_id
14184: FROM per_all_assignments_f asl
14185: ,per_all_assignments_f asl2
14186: ,pay_payroll_actions ppa
14187: ,pay_assignment_actions paa
14188: ,per_time_periods ptp
14189: WHERE asl.person_id = asl2.person_id
14190: AND asl2.assignment_id = c_assg_id

Line 14683: pay_payroll_actions ppa,

14679: ,p_prev_corr_year VARCHAR2)
14680: IS
14681: select max(paa.assignment_action_id) assignment_action_id, ptp.start_date, ptp.end_date
14682: from
14683: pay_payroll_actions ppa,
14684: pay_assignment_actions paa,
14685: per_time_periods ptp
14686: where
14687: ppa.action_type in ('R', 'Q')

Line 14716: ,pay_payroll_actions ppa1

14712: ,pay_retro_component_usages rcu
14713: ,pay_retro_components rc
14714: ,pay_element_entries_f pee1
14715: ,pay_assignment_actions paa1
14716: ,pay_payroll_actions ppa1
14717: ,per_time_periods ptp
14718: WHERE --paa1.source_action_id = paa.assignment_action_id
14719: paa1.assignment_action_id = paa.assignment_action_id
14720: AND rr1.assignment_action_id = paa1.assignment_action_id

Line 14751: ,pay_payroll_actions ppa

14747: ,pay_retro_component_usages rcu
14748: ,pay_retro_components rc
14749: ,pay_element_entries_f pee1
14750: ,pay_assignment_actions paa
14751: ,pay_payroll_actions ppa
14752: ,per_time_periods ptp
14753: WHERE paa.assignment_action_id = c_assignment_action_id
14754: AND rr1.assignment_action_id = paa.assignment_action_id
14755: AND rr1.element_entry_id = pee1.element_entry_id

Line 14895: ,pay_payroll_actions generator

14891: ,c_tax_unit_id IN NUMBER) IS
14892:
14893: SELECT sum (fnd_number.canonical_to_number(nvl (action_information6,0))) taxableincome
14894: FROM pay_action_information info
14895: ,pay_payroll_actions generator
14896: ,pay_payroll_actions datalock
14897: WHERE info.action_context_id = generator.payroll_action_id
14898: AND info.action_information2 = 'TotLnLbPh'
14899: AND datalock.report_type = 'NL_WAGES_REP_LOCK'

Line 14896: ,pay_payroll_actions datalock

14892:
14893: SELECT sum (fnd_number.canonical_to_number(nvl (action_information6,0))) taxableincome
14894: FROM pay_action_information info
14895: ,pay_payroll_actions generator
14896: ,pay_payroll_actions datalock
14897: WHERE info.action_context_id = generator.payroll_action_id
14898: AND info.action_information2 = 'TotLnLbPh'
14899: AND datalock.report_type = 'NL_WAGES_REP_LOCK'
14900: AND datalock.business_group_id = c_bg_id