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.PSP_ENC_CREATE_LINES dependencies on PER_TIME_PERIODS

Line 463: INDEX(ptp PER_TIME_PERIODS_N50)

459: PRAGMA AUTONOMOUS_TRANSACTION;
460:
461: cursor oracle_payroll_asg_end_date is
462: SELECT /*+ use_nl(PTP)
463: INDEX(ptp PER_TIME_PERIODS_N50)
464: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
465: Max(ptp.end_date)
466: FROM pay_payroll_actions ppa,
467: pay_assignment_actions paa,

Line 468: per_time_periods ptp

464: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
465: Max(ptp.end_date)
466: FROM pay_payroll_actions ppa,
467: pay_assignment_actions paa,
468: per_time_periods ptp
469: WHERE paa.assignment_id = p_assignmnet_id
470: AND ppa.payroll_action_id = paa.payroll_action_id
471: AND ppa.business_group_id = p_business_group_id
472: AND ppa.payroll_id = p_payroll_id

Line 481: INDEX(ptp PER_TIME_PERIODS_N50)

477:
478:
479: cursor non_oracle_asg_end_date is
480: SELECT /*+ use_nl(PTP)
481: INDEX(ptp PER_TIME_PERIODS_N50)
482: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
483: max (ptp.end_date)
484: FROM pay_payroll_actions ppa
485: , pay_assignment_actions paa

Line 486: , per_time_periods ptp

482: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
483: max (ptp.end_date)
484: FROM pay_payroll_actions ppa
485: , pay_assignment_actions paa
486: , per_time_periods ptp
487: WHERE paa.assignment_id (+) = p_assignmnet_id
488: AND ppa.payroll_action_id = paa.payroll_action_id (+)
489: AND ppa.business_group_id = p_business_group_id
490: AND ppa.payroll_id = p_payroll_id

Line 565: SELECT /+ INDEX(ptp PER_TIME_PERIODS_N50)/

561: function get_payroll_pay_end_date(p_payroll_id IN NUMBER
562: ) return date IS
563:
564: cursor payroll_pay_end_date_cur(p_payroll_id number) is
565: SELECT /*+ INDEX(ptp PER_TIME_PERIODS_N50)*/
566: max (ptp.end_date)
567: FROM pay_payroll_actions ppa
568: ,pay_assignment_actions paa
569: ,per_time_periods ptp

Line 569: ,per_time_periods ptp

565: SELECT /*+ INDEX(ptp PER_TIME_PERIODS_N50)*/
566: max (ptp.end_date)
567: FROM pay_payroll_actions ppa
568: ,pay_assignment_actions paa
569: ,per_time_periods ptp
570: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
571: AND ppa.payroll_id = p_payroll_id
572: AND ppa.action_type IN ('R','Q')
573: AND nvl (paa.action_status,ppa.action_status) = 'C'

Line 854: per_time_periods ptp

850: pay_element_types_f pet,
851: psp_enc_elements peel,
852: per_assignments_f paf,
853: per_assignment_status_types past,
854: per_time_periods ptp
855: WHERE peev.element_entry_id = pee.element_entry_id
856: AND peev.effective_start_date <= paf.effective_end_date
857: AND peev.effective_end_date >= paf.effective_start_date
858: AND pel.element_link_id = pee.element_link_id

Line 1603: FROM per_time_periods ptp,

1599: 5, ptp.cut_off_date) effective_date,
1600: 'Y',
1601: 0,
1602: NULL
1603: FROM per_time_periods ptp,
1604: per_all_assignments_f paf,
1605: per_assignment_status_types past
1606: WHERE ptp.payroll_id = p_payroll_id
1607: AND paf.assignment_id = p_assignment_id

Line 6908: INDEX(ptp PER_TIME_PERIODS_N50) */

6904:
6905:
6906: CURSOR c_last_pay_run (p_assignment_id NUMBER)IS
6907: SELECT /*+ INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
6908: INDEX(ptp PER_TIME_PERIODS_N50) */
6909: Max(ptp.end_date)
6910: FROM pay_payroll_actions ppa,
6911: pay_assignment_actions paa,
6912: per_time_periods ptp

Line 6912: per_time_periods ptp

6908: INDEX(ptp PER_TIME_PERIODS_N50) */
6909: Max(ptp.end_date)
6910: FROM pay_payroll_actions ppa,
6911: pay_assignment_actions paa,
6912: per_time_periods ptp
6913: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
6914: AND ppa.business_group_id = l_business_group_id
6915: AND ppa.payroll_id = l_payroll_id
6916: AND NVL(paa.assignment_id, p_assignment_id) = p_assignment_id

Line 6929: FROM per_time_periods ptp

6925:
6926:
6927: CURSOR c_tp_start_date IS
6928: SELECT MIN(ptp.start_date)
6929: FROM per_time_periods ptp
6930: WHERE ptp.payroll_id = l_payroll_id;
6931:
6932: CURSOR c_obtain_eff_date_option IS
6933: SELECT NVL(parameter_value,1)

Line 8856: per_time_periods ptp

8852: CURSOR c_last_pay_run IS
8853: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8854: FROM pay_payroll_actions ppa,
8855: pay_assignment_actions paa,
8856: per_time_periods ptp
8857: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
8858: AND ppa.business_group_id = l_business_group_id
8859: AND ppa.payroll_id = p_payroll_id
8860: AND ppa.action_type IN ( 'R','Q')

Line 8867: FROM per_time_periods ptp

8863: and ptp.payroll_id = ppa.payroll_id;
8864:
8865: CURSOR c_tp_start_date IS
8866: SELECT MIN(ptp.start_date)
8867: FROM per_time_periods ptp
8868: WHERE ptp.payroll_id= p_payroll_id;
8869:
8870: CURSOR asg_number_cur (p_start_date IN DATE) IS
8871: SELECT assignment_number,

Line 9458: INDEX(ptp PER_TIME_PERIODS_N50)

9454: AND pesl.status_code IN ('A', 'N')
9455: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
9456: AND pesl.effective_date > (NVL((SELECT /*+
9457: INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
9458: INDEX(ptp PER_TIME_PERIODS_N50)
9459: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4) */
9460: Max(ptp.end_date)
9461: FROM pay_payroll_actions ppa,
9462: per_time_periods ptp,

Line 9462: per_time_periods ptp,

9458: INDEX(ptp PER_TIME_PERIODS_N50)
9459: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4) */
9460: Max(ptp.end_date)
9461: FROM pay_payroll_actions ppa,
9462: per_time_periods ptp,
9463: pay_assignment_actions paa
9464: WHERE paa.assignment_id(+) = pesl.assignment_id
9465: AND ppa.payroll_action_id = paa.payroll_action_id (+)
9466: -- AND ppa.time_period_id = ptp.time_period_id -- Commented for the Bug 12647364