DBA Data[Home] [Help]

APPS.PAY_KR_MAGTAPE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 32: pay_assignment_actions paa,

28: pay_payroll_actions ppa2,
29: (
30: select ppp.org_payment_method_id
31: from pay_pre_payments ppp,
32: pay_assignment_actions paa,
33: pay_payroll_actions ppa
34: where ppa.payroll_action_id = p_payroll_action_id
35: and paa.payroll_action_id = ppa.payroll_action_id
36: and ppp.pre_payment_id = paa.pre_payment_id

Line 80: pay_assignment_actions paa2, -- PrePayment assact

76: per_assignments_f pa,
77: pay_external_accounts pea,
78: pay_personal_payment_methods_f ppm,
79: pay_payroll_actions ppa2, -- PrePayment pact
80: pay_assignment_actions paa2, -- PrePayment assact
81: pay_pre_payments ppp,
82: pay_assignment_actions paa -- Magtape assact
83: where paa.payroll_action_id = p_payroll_action_id
84: and ppp.pre_payment_id = paa.pre_payment_id

Line 82: pay_assignment_actions paa -- Magtape assact

78: pay_personal_payment_methods_f ppm,
79: pay_payroll_actions ppa2, -- PrePayment pact
80: pay_assignment_actions paa2, -- PrePayment assact
81: pay_pre_payments ppp,
82: pay_assignment_actions paa -- Magtape assact
83: where paa.payroll_action_id = p_payroll_action_id
84: and ppp.pre_payment_id = paa.pre_payment_id
85: and ppp.org_payment_method_id + 0 = p_org_payment_method_id
86: and paa2.assignment_action_id = ppp.assignment_action_id