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 PAY_PAYROLL_ACTIONS

Line 6638: FROM pay_payroll_actions ppa,

6634:
6635: /* Bug 5642002: Replaced earned date with period end date */
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

Line 6673: FROM pay_payroll_actions

6669: AND pel.payroll_id = l_payroll_id;
6670:
6671: CURSOR cel_request_id_cur IS
6672: SELECT request_id
6673: FROM pay_payroll_actions
6674: WHERE payroll_action_id = p_payroll_action_id;
6675:
6676: CURSOR asg_number_cur (p_effective_date IN DATE) IS
6677: SELECT assignment_number,

Line 7242: FROM pay_payroll_actions ppa,

7238: AND pesl.payroll_id = l_payroll_id
7239: AND status_code = 'A'
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

Line 7265: FROM pay_payroll_actions ppa,

7261: AND pesl.payroll_id = l_payroll_id
7262: AND status_code = 'A'
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

Line 8530: FROM pay_payroll_actions ppa,

8526:
8527: /* Bug 5642002: Replaced earned date with period end date */
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

Line 8689: FROM pay_payroll_actions ppa,

8685: AND pa.business_group_id = l_business_group_id
8686: -- AND pa.effective_end_date >= l_enc_begin_date
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 (+)

Line 8720: FROM pay_payroll_actions ppa,

8716: WHERE pesl.assignment_id = pa.assignment_id
8717: AND pesl.status_code IN ('A', 'N')
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 (+)

Line 8746: FROM pay_payroll_actions ppa,

8742: WHERE pa.payroll_id = p_payroll_id
8743: AND pa.assignment_type = 'E'
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 (+)

Line 8790: FROM pay_payroll_actions ppa,

8786: AND pa.business_group_id = l_business_group_id
8787: AND pa.effective_end_date >= l_enc_begin_date
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 (+)

Line 8839: FROM pay_payroll_actions ppa,

8835: AND pepa.assignment_id = pa.assignment_id
8836: AND pa.effective_end_date >= l_enc_begin_date
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 (+)

Line 8862: FROM pay_payroll_actions ppa,

8858: WHERE pesl.assignment_id = pa.assignment_id
8859: AND pesl.status_code IN ('A', 'N')
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 (+)

Line 8887: FROM pay_payroll_actions ppa,

8883: AND pepa.business_group_id = l_business_group_id
8884: AND pepa.set_of_books_id = l_set_of_books_id
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 (+)

Line 8922: FROM pay_payroll_actions ppa,

8918: AND pa.business_group_id = l_business_group_id
8919: AND pa.effective_end_date >= l_enc_begin_date
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 (+)

Line 8966: FROM pay_payroll_actions ppa,

8962: AND status_code = 'A'
8963: AND effective_date <= l_enc_begin_date
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 (+)

Line 8987: FROM pay_payroll_actions ppa,

8983: WHERE pesl2.assignment_id = pesl.assignment_id
8984: AND pesl2.status_code = 'N'
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 (+)