APPS.PAY_ZA_EFT_RECONCILIATION dependencies on PAY_PAYROLL_ACTIONS

Line 23: pay_payroll_actions ppa,

19: Select to_char(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date)), 'YYYY/MM/DD')
20: from pay_assignment_actions paa,
21: pay_pre_payments ppp,
22: pay_assignment_actions paa2,
23: pay_payroll_actions ppa,
24: per_time_periods ptp
25: where paa.assignment_action_id = p_assignment_action_id
26: and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID
27: and paa2.assignment_action_id = ( select max(locked_action_id)

Line 38: PAY_PAYROLL_ACTIONS PPA,

34:
35: CURSOR get_acb_code (p_effective_date date) IS
36: select SEGMENT2
37: from pay_payrolls_f PPF,
38: PAY_PAYROLL_ACTIONS PPA,
39: hr_soft_coding_keyflex SOK
40: where PPA.payroll_action_id = p_payroll_action_id
41: and PPA.payroll_id = PPF.payroll_id
42: and PPF.SOFT_CODING_KEYFLEX_ID = SOK.SOFT_CODING_KEYFLEX_ID

Line 60: pay_payroll_actions ppa

56: select ppa.effective_date
57: from pay_assignment_actions paa,
58: pay_pre_payments ppp,
59: pay_assignment_actions paa2,
60: pay_payroll_actions ppa
61: where paa.assignment_action_id = p_assignment_action_id
62: and paa.PRE_PAYMENT_ID = ppp.PRE_PAYMENT_ID
63: and paa2.assignment_action_id = ( select max(locked_action_id)
64: from pay_action_interlocks pai

Line 72: from pay_payroll_actions ppa,

68:
69: CURSOR inst_code_and_type IS
70: select substr(hoi.org_information1, 1, 80),
71: substr(hoi.org_information2, 1, 80)
72: from pay_payroll_actions ppa,
73: hr_organization_information hoi,
74: hr_organization_units hou
75: where ppa.payroll_action_id = p_payroll_action_id
76: and hou.organization_id = ppa.business_group_id

Line 97: FROM pay_payroll_actions

93: BEGIN
94:
95: SELECT BUSINESS_GROUP_ID
96: INTO l_business_grp_id
97: FROM pay_payroll_actions
98: WHERE PAYROLL_ACTION_ID = p_payroll_action_id;
99:
100:
101: Select hruserdt.get_table_value(l_business_grp_id,