APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 70: pay_payroll_actions ppa,

66: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
67: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
68: paa.assignment_action_id),16))
69: FROM pay_assignment_actions paa,
70: pay_payroll_actions ppa,
71: per_time_periods ptp,
72: fnd_sessions ses
73: WHERE paa.assignment_id = p_asg
74: --AND paa.action_status = 'C'

Line 98: pay_payroll_actions ppa,

94: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
95: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
96: paa.assignment_action_id),16))
97: FROM pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: fnd_sessions ses,
100: per_time_periods ptp
101: WHERE paa.assignment_id = p_asg
102: --AND paa.action_status = 'C'

Line 1447: pay_payroll_actions ppa

1443: FROM pay_run_results prr,
1444: pay_run_result_values prrv,
1445: pay_assignment_actions pac,
1446: pay_input_values_f piv ,
1447: pay_payroll_actions ppa
1448: WHERE prr.run_result_id = prrv.run_result_id
1449: AND prr.entry_type = 'E'
1450: AND PRR.source_type IN ('E', 'I')
1451: AND prr.source_id = p_element_entry_id

Line 1460: pay_payroll_actions ppa1

1456: AND ppa.payroll_action_id = pac.payroll_action_id
1457: AND pac.assignment_action_id = (SELECT max(pac1.assignment_action_id)
1458: FROM pay_assignment_actions pac1,
1459: pay_run_results prr1,
1460: pay_payroll_actions ppa1
1461: WHERE pac1.assignment_action_id <> p_asg_action_id
1462: AND pac1.assignment_action_id = prr1.assignment_action_id
1463: AND ppa1.payroll_action_id = pac1.payroll_action_id
1464: AND prr1.source_id = p_element_entry_id

Line 1481: pay_payroll_actions PPA

1477: IS
1478: SELECT PRR.run_result_id
1479: FROM pay_run_results PRR,
1480: pay_assignment_actions ASA,
1481: pay_payroll_actions PPA
1482: WHERE PRR.source_id = p_element_entry_id
1483: AND PRR.source_type IN ('E', 'I')
1484: AND PRR.status in ('P', 'PA', 'R', 'O')
1485: AND ASA.assignment_action_id = PRR.assignment_action_id

Line 1584: FROM PAY_PAYROLL_ACTIONS PPA,

1580:
1581: cursor c_asg_actions (p_start_date date, p_end_date date)
1582: is
1583: SELECT MAX(ASSIGNMENT_ACTION_ID) assignment_action_id
1584: FROM PAY_PAYROLL_ACTIONS PPA,
1585: PAY_ASSIGNMENT_ACTIONS PAA,
1586: PER_ALL_ASSIGNMENTS_F PAAF,
1587: PER_TIME_PERIODS PTP
1588: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID