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 3006: ,per_time_periods ptp1

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

Line 3007: ,per_time_periods ptp2

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

Line 4301: ,per_time_periods ptp

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'
4305: AND c_payroll_type = 'MONTH') OR

Line 4443: ,per_time_periods ptp

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')
4447: AND ppa.action_status = 'C'

Line 6045: ,per_time_periods ptp

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

Line 6102: ,per_time_periods ptp

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

Line 6137: ,per_time_periods ptp

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')
6141: AND paa.ACTION_STATUS = 'C'

Line 6152: ,per_time_periods ptp

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')
6156: AND paa.ACTION_STATUS = 'C'

Line 6175: FROM per_time_periods ptp

6171: ORDER BY 1;
6172: --
6173: CURSOR csr_get_period(c_payroll_id NUMBER,c_date DATE) IS
6174: SELECT ptp.start_date,ptp.end_date
6175: FROM per_time_periods ptp
6176: WHERE ptp.payroll_id = c_payroll_id
6177: AND c_date between ptp.start_date and ptp.end_date;
6178: --
6179: CURSOR csr_get_table_id(c_table_name VARCHAR2) IS

Line 8428: ,per_time_periods ptp

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')
8432: AND paa.ACTION_STATUS = 'C'

Line 8444: ,per_time_periods ptp

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')
8448: AND paa.ACTION_STATUS = 'C'

Line 8467: FROM per_time_periods ptp

8463: ORDER BY 1;
8464: --
8465: CURSOR csr_get_period(c_payroll_id NUMBER,c_date DATE) IS
8466: SELECT ptp.start_date,ptp.end_date
8467: FROM per_time_periods ptp
8468: WHERE ptp.payroll_id = c_payroll_id
8469: AND c_date between ptp.start_date and ptp.end_date;
8470: --
8471: CURSOR csr_get_element_det(c_element_name VARCHAR2