APPS.PAY_NL_GENERAL dependencies on PER_TIME_PERIODS

Line 292: FROM per_time_periods ptp,

288: c_date_earned in pay_payroll_actions.date_earned%TYPE
289: ) is
290:
291: SELECT ptp.start_date
292: FROM per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa,
295: pay_run_results prr,
296: pay_element_entries_f pee

Line 312: FROM per_time_periods ptp,

308: c_date_earned in pay_payroll_actions.date_earned%TYPE
309: ) is
310:
311: SELECT ptp.start_date
312: FROM per_time_periods ptp,
313: pay_payroll_actions ppa,
314: pay_assignment_actions paa,
315: pay_run_results prr,
316: pay_element_entries_f pee

Line 332: FROM per_time_periods ptp,

328: c_date_earned in pay_payroll_actions.date_earned%TYPE
329: ) is
330:
331: SELECT ptp.start_date
332: FROM per_time_periods ptp,
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: pay_run_results prr,
336: pay_element_entries_f pee

Line 351: FROM per_time_periods ptp,

347: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
348: c_date_earned in pay_payroll_actions.date_earned%TYPE
349: ) is
350: SELECT ptp.start_date
351: FROM per_time_periods ptp,
352: pay_payroll_actions ppa,
353: pay_assignment_actions paa,
354: pay_element_entries_f pee
355: WHERE pee.element_entry_id=c_element_entry_id

Line 1782: ,per_time_periods TPERIOD

1778:
1779: cursor csr_get_num_periods(c_payroll_action_id NUMBER) is
1780: select max(TPERIOD.period_num) from
1781: pay_payroll_actions PACTION
1782: ,per_time_periods TPERIOD
1783: where PACTION.payroll_action_id = c_payroll_action_id
1784: and TPERIOD.payroll_id = PACTION.payroll_id
1785: and to_char(PACTION.date_earned,'YYYY') = to_char(TPERIOD.regular_payment_date,'YYYY');
1786:

Line 1850: ,per_time_periods ptp

1846: ,ppa.action_status
1847: ,ppa.date_earned
1848: ,ppa.business_group_id
1849: FROM pay_payroll_actions ppa
1850: ,per_time_periods ptp
1851: WHERE ppa.payroll_action_id = c_payroll_action_id
1852: AND ptp.time_period_id = ppa.time_period_id;
1853: --
1854: CURSOR csr_get_all_ass(c_assignment_id NUMBER

Line 2035: ,per_time_periods ptp

2031: ,ppa.action_status
2032: ,ppa.date_earned
2033: ,ppa.business_group_id
2034: FROM pay_payroll_actions ppa
2035: ,per_time_periods ptp
2036: WHERE ppa.payroll_action_id = c_payroll_action_id
2037: AND ptp.time_period_id = ppa.time_period_id;
2038: --
2039: CURSOR csr_get_all_ass(c_assignment_id NUMBER

Line 2266: ,per_time_periods ptp

2262: ,ptp.end_date
2263: ,ppa.date_earned
2264: ,business_group_id
2265: FROM pay_payroll_actions ppa
2266: ,per_time_periods ptp
2267: WHERE ppa.payroll_action_id = c_payroll_action_id
2268: AND ptp.time_period_id = ppa.time_period_id;
2269: --
2270: CURSOR csr_chk_pog_exist(c_assignment_id NUMBER

Line 2504: ,per_time_periods ptp

2500: ,ptp.end_date
2501: ,ppa.date_earned
2502: ,business_group_id
2503: FROM pay_payroll_actions ppa
2504: ,per_time_periods ptp
2505: WHERE ppa.payroll_action_id = c_payroll_action_id
2506: AND ptp.time_period_id = ppa.time_period_id;
2507: --
2508: CURSOR csr_chk_pog_exist(c_assignment_id NUMBER