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_ASSIGNMENT_ACTIONS

Line 6516: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;

6512:
6513: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_asg_array.COUNT: ' || t_asg_array.COUNT);
6514: FOR recno IN 1..t_asg_array.COUNT
6515: LOOP
6516: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;
6517: hr_nonrun_asact.insact(l_asg_action_id,
6518: pactid => p_pactid,
6519: chunk => p_chunk_num,
6520: object_id => t_asg_array(recno),

Line 6639: pay_assignment_actions paa,

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
6643: AND ppa.payroll_id = l_payroll_id

Line 7243: pay_assignment_actions paa,

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
7247: AND ppa.action_type IN( 'R','Q')

Line 7266: pay_assignment_actions paa,

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
7270: AND ppa.action_type IN( 'R','Q')

Line 8531: pay_assignment_actions paa,

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
8535: AND ppa.payroll_id = p_payroll_id

Line 8690: pay_assignment_actions paa,

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 (+)
8694: AND ppa.business_group_id = pa.business_group_id

Line 8721: pay_assignment_actions paa,

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 (+)
8725: AND ppa.business_group_id = pesl.business_group_id

Line 8747: pay_assignment_actions paa,

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 (+)
8751: and ppa.business_group_id = pa.business_group_id

Line 8791: pay_assignment_actions paa,

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 (+)
8795: AND ppa.business_group_id = pa.business_group_id

Line 8840: pay_assignment_actions paa,

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 (+)
8844: AND ppa.business_group_id = pa.business_group_id

Line 8863: pay_assignment_actions paa,

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 (+)
8867: AND ppa.time_period_id = ptp.time_period_id

Line 8888: pay_assignment_actions paa,

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 (+)
8892: and ppa.business_group_id = pa.business_group_id

Line 8923: pay_assignment_actions paa,

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 (+)
8927: AND ppa.business_group_id = pa.business_group_id

Line 8967: pay_assignment_actions paa,

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 (+)
8971: AND ppa.business_group_id = pesl.business_group_id

Line 8988: pay_assignment_actions paa,

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 (+)
8992: AND ppa.business_group_id = pesl2.business_group_id