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 652: per_time_periods ptp

648: pay_element_types_f pet,
649: psp_enc_elements peel,
650: per_assignments_f paf,
651: per_assignment_status_types past,
652: per_time_periods ptp
653: WHERE peev.element_entry_id = pee.element_entry_id
654: AND peev.effective_start_date <= paf.effective_end_date
655: AND peev.effective_end_date >= paf.effective_start_date
656: AND pel.element_link_id = pee.element_link_id

Line 1388: FROM per_time_periods ptp,

1384: 5, ptp.cut_off_date) effective_date,
1385: 'Y',
1386: 0,
1387: NULL
1388: FROM per_time_periods ptp,
1389: per_all_assignments_f paf,
1390: per_assignment_status_types past
1391: WHERE ptp.payroll_id = p_payroll_id
1392: AND paf.assignment_id = p_assignment_id

Line 6640: per_time_periods ptp

6636: CURSOR c_last_pay_run (p_assignment_id NUMBER)IS
6637: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
6638: FROM pay_payroll_actions ppa,
6639: pay_assignment_actions paa,
6640: per_time_periods ptp
6641: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
6642: AND ppa.business_group_id = l_business_group_id
6643: AND ppa.payroll_id = l_payroll_id
6644: AND NVL(paa.assignment_id, p_assignment_id) = p_assignment_id

Line 6652: FROM per_time_periods ptp

6648: and ptp.payroll_id = ppa.payroll_id;
6649:
6650: CURSOR c_tp_start_date IS
6651: SELECT MIN(ptp.start_date)
6652: FROM per_time_periods ptp
6653: WHERE ptp.payroll_id = l_payroll_id;
6654:
6655: CURSOR c_obtain_eff_date_option IS
6656: SELECT NVL(parameter_value,1)

Line 7244: per_time_periods ptp

7240: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id
7241: AND pesl.effective_date <= (NVL((SELECT MAX (ptp.end_date)--MAX(ppa.date_earned): Bug 5642002: Replaced earned date with period end date
7242: FROM pay_payroll_actions ppa,
7243: pay_assignment_actions paa,
7244: per_time_periods ptp
7245: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
7246: AND ppa.payroll_id = l_payroll_id
7247: AND ppa.action_type IN( 'R','Q')
7248: AND NVL(paa.action_status, ppa.action_status) = 'C'

Line 7267: per_time_periods ptp

7263: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id
7264: AND pesl.effective_date > (NVL((SELECT MAX (ptp.end_date)--MAX(ppa.date_earned): Bug 5642002: Replaced earned date with period end date
7265: FROM pay_payroll_actions ppa,
7266: pay_assignment_actions paa,
7267: per_time_periods ptp
7268: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
7269: AND ppa.payroll_id = l_payroll_id
7270: AND ppa.action_type IN( 'R','Q')
7271: AND NVL(paa.action_status, ppa.action_status) = 'C'

Line 8532: per_time_periods ptp

8528: CURSOR c_last_pay_run IS
8529: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8530: FROM pay_payroll_actions ppa,
8531: pay_assignment_actions paa,
8532: per_time_periods ptp
8533: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
8534: AND ppa.business_group_id = l_business_group_id
8535: AND ppa.payroll_id = p_payroll_id
8536: AND ppa.action_type IN ( 'R','Q')

Line 8543: FROM per_time_periods ptp

8539: and ptp.payroll_id = ppa.payroll_id;
8540:
8541: CURSOR c_tp_start_date IS
8542: SELECT MIN(ptp.start_date)
8543: FROM per_time_periods ptp
8544: WHERE ptp.payroll_id= p_payroll_id;
8545:
8546: CURSOR asg_number_cur (p_start_date IN DATE) IS
8547: SELECT assignment_number,

Line 8691: per_time_periods ptp

8687: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8688: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8689: FROM pay_payroll_actions ppa,
8690: pay_assignment_actions paa,
8691: per_time_periods ptp
8692: WHERE paa.assignment_id(+) = pa.assignment_id
8693: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8694: AND ppa.business_group_id = pa.business_group_id
8695: AND ppa.payroll_id = pa.payroll_id

Line 8722: per_time_periods ptp

8718: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8719: AND pesl.effective_date > (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8720: FROM pay_payroll_actions ppa,
8721: pay_assignment_actions paa,
8722: per_time_periods ptp
8723: WHERE paa.assignment_id(+) = pesl.assignment_id
8724: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8725: AND ppa.business_group_id = pesl.business_group_id
8726: AND ppa.payroll_id = pesl.payroll_id

Line 8748: per_time_periods ptp

8744: AND pa.business_group_id = l_business_group_id
8745: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8746: FROM pay_payroll_actions ppa,
8747: pay_assignment_actions paa,
8748: per_time_periods ptp
8749: WHERE paa.assignment_id(+) = pa.assignment_id
8750: and ppa.payroll_action_id = paa.payroll_action_id (+)
8751: and ppa.business_group_id = pa.business_group_id
8752: AND ppa.payroll_id = pa.payroll_id

Line 8792: per_time_periods ptp

8788: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8789: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8790: FROM pay_payroll_actions ppa,
8791: pay_assignment_actions paa,
8792: per_time_periods ptp
8793: WHERE paa.assignment_id(+) = pa.assignment_id
8794: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8795: AND ppa.business_group_id = pa.business_group_id
8796: AND ppa.payroll_id = pa.payroll_id

Line 8841: per_time_periods ptp

8837: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8838: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8839: FROM pay_payroll_actions ppa,
8840: pay_assignment_actions paa,
8841: per_time_periods ptp
8842: WHERE paa.assignment_id(+) = pa.assignment_id
8843: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8844: AND ppa.business_group_id = pa.business_group_id
8845: AND ppa.payroll_id = pa.payroll_id

Line 8864: per_time_periods ptp

8860: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8861: AND pesl.effective_date > (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8862: FROM pay_payroll_actions ppa,
8863: pay_assignment_actions paa,
8864: per_time_periods ptp
8865: WHERE paa.assignment_id(+) = pesl.assignment_id
8866: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8867: AND ppa.time_period_id = ptp.time_period_id
8868: AND ppa.business_group_id = pesl.business_group_id

Line 8889: per_time_periods ptp

8885: AND pepa.assignment_id = pa.assignment_id
8886: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8887: FROM pay_payroll_actions ppa,
8888: pay_assignment_actions paa,
8889: per_time_periods ptp
8890: WHERE paa.assignment_id(+)= pa.assignment_id
8891: and ppa.payroll_action_id = paa.payroll_action_id (+)
8892: and ppa.business_group_id = pa.business_group_id
8893: AND ppa.payroll_id = pa.payroll_id

Line 8924: per_time_periods ptp

8920: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8921: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8922: FROM pay_payroll_actions ppa,
8923: pay_assignment_actions paa,
8924: per_time_periods ptp
8925: WHERE paa.assignment_id(+) = pa.assignment_id
8926: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8927: AND ppa.business_group_id = pa.business_group_id
8928: AND ppa.payroll_id = pa.payroll_id

Line 8968: per_time_periods ptp

8964: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8965: AND pesl.effective_date <= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8966: FROM pay_payroll_actions ppa,
8967: pay_assignment_actions paa,
8968: per_time_periods ptp
8969: WHERE paa.assignment_id(+) = pesl.assignment_id
8970: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8971: AND ppa.business_group_id = pesl.business_group_id
8972: AND ppa.payroll_id = pesl.payroll_id

Line 8989: per_time_periods ptp

8985: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8986: AND pesl2.effective_date <= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8987: FROM pay_payroll_actions ppa,
8988: pay_assignment_actions paa,
8989: per_time_periods ptp
8990: WHERE paa.assignment_id(+) = pesl2.assignment_id
8991: AND ppa.payroll_action_id = paa.payroll_action_id (+)
8992: AND ppa.business_group_id = pesl2.business_group_id
8993: AND ppa.payroll_id = pesl2.payroll_id