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 PER_TIME_PERIODS

Line 4524: ,per_time_periods ptp1

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
4528: WHERE paa1.assignment_action_id = c_ass_act_id

Line 4525: ,per_time_periods ptp2

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
4528: WHERE paa1.assignment_action_id = c_ass_act_id
4529: AND paa1.payroll_action_id = ppa1.payroll_action_id

Line 4609: from per_time_periods

4605: -- bug 14125837 begin
4606: /*CURSOR C_ER_CORR_PD(p_payroll_id NUMBER, p_start_date DATE, p_end_date DATE, p_tax_unit_id NUMBER, c_payroll_type VARCHAR2) --10100628
4607: IS
4608: SELECT DISTINCT START_DATE, END_DATE
4609: from per_time_periods
4610: where
4611: PAYROLL_ID = p_payroll_id
4612: --AND p_start_date BETWEEN START_DATE AND END_DATE
4613: AND (START_DATE BETWEEN p_start_date AND p_end_date

Line 4633: from per_time_periods

4629: ORDER by 1 asc; */
4630: CURSOR C_ER_CORR_PD(p_payroll_id NUMBER, p_start_date DATE, p_end_date DATE, p_tax_unit_id NUMBER, c_payroll_type VARCHAR2) --10100628
4631: IS
4632: SELECT DISTINCT START_DATE, END_DATE
4633: from per_time_periods
4634: where
4635: PAYROLL_ID = p_payroll_id
4636: --AND p_start_date BETWEEN START_DATE AND END_DATE
4637: AND (START_DATE BETWEEN p_start_date AND p_end_date

Line 7189: ,per_time_periods ptp

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
7192: AND ((ppf.period_type = 'Calendar Month'
7193: AND c_payroll_type = 'MONTH') OR

Line 7331: ,per_time_periods ptp

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
7334: AND ppa.action_type in ('R','Q')
7335: AND ppa.action_status = 'C'

Line 7389: ,per_time_periods ptp

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
7392: AND ((ppf.period_type = 'Calendar Month'
7393: AND c_payroll_type = 'MONTH') OR

Line 7438: ,per_time_periods ptp

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

Line 9713: ,per_time_periods ptp

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')
9717: AND pee.assignment_id = paa.assignment_id

Line 9770: ,per_time_periods ptp

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
9774: AND pee1.creator_type = 'RR'

Line 9805: ,per_time_periods ptp

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')
9809: AND paa.ACTION_STATUS IN ('C','S') -- 10228241

Line 9821: ,per_time_periods ptp

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')
9825: AND paa.ACTION_STATUS IN ('C','S') -- 10228241

Line 9844: FROM per_time_periods ptp

9840: ORDER BY 1;
9841: --
9842: CURSOR csr_get_period(c_payroll_id NUMBER,c_date DATE) IS
9843: SELECT ptp.start_date,ptp.end_date
9844: FROM per_time_periods ptp
9845: WHERE ptp.payroll_id = c_payroll_id
9846: AND c_date between ptp.start_date and ptp.end_date;
9847: --
9848: CURSOR csr_get_table_id(c_table_name VARCHAR2) IS

Line 9991: ,per_time_periods ptp

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
9994: AND ppf.payroll_id = asl.payroll_id
9995: AND ((ppf.period_type = 'Calendar Month' AND c_payroll_type = 'MONTH') OR

Line 10132: per_time_periods ptp

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')
10135: and ppa.payroll_action_id = paa.payroll_action_id
10136: and paa.assignment_id = p_asg_id

Line 14017: ,per_time_periods ptp

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')
14021: AND paa.ACTION_STATUS IN ('C','S') -- 10228241

Line 14034: ,per_time_periods ptp

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')
14038: AND paa.ACTION_STATUS IN ('C','S') -- 10228241

Line 14057: FROM per_time_periods ptp

14053: ORDER BY 1;
14054: --
14055: CURSOR csr_get_period(c_payroll_id NUMBER,c_date DATE) IS
14056: SELECT ptp.start_date,ptp.end_date
14057: FROM per_time_periods ptp
14058: WHERE ptp.payroll_id = c_payroll_id
14059: AND c_date between ptp.start_date and ptp.end_date;
14060: --
14061: CURSOR csr_get_element_det(c_element_name VARCHAR2

Line 14188: ,per_time_periods ptp

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
14191: AND ppa.payroll_id = asl.payroll_id
14192: AND ppa.action_type in ('R','Q')

Line 14685: per_time_periods ptp

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')
14688: and ppa.payroll_action_id = paa.payroll_action_id
14689: and paa.assignment_id = p_assignment_id

Line 14717: ,per_time_periods ptp

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

Line 14752: ,per_time_periods ptp

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
14756: AND pee1.creator_type = 'RR'