DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 36: pay_org_payment_methods_f popm

32: FROM pay_payroll_actions ppa,
33: pay_assignment_actions paa,
34: pay_pre_payments ppp,
35: pay_action_interlocks pai,
36: pay_org_payment_methods_f popm
37: WHERE (ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
38: ('TRANSFER_PAYROLL_ACTION_ID')
39: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
40: ('PAYROLL_ACTION_ID'))

Line 56: ,pay_org_payment_methods_f popm

52: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
53: FROM pay_assignment_actions paa
54: ,pay_action_interlocks pai
55: ,pay_pre_payments ppp
56: ,pay_org_payment_methods_f popm
57: ,pay_assignment_actions paa2
58: ,pay_payroll_actions ppa
59: WHERE (paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
60: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))

Line 89: , pay_org_payment_methods_f popm

85: , pay_assignment_actions paa
86: , pay_assignment_actions paa_chq
87: , pay_payroll_actions ppa
88: , pay_payroll_actions ppa_chq
89: , pay_org_payment_methods_f popm
90: WHERE paa_chq.assignment_action_id = pay_magtape_generic.get_parameter_value
91: ('TRANSFER_ACT_ID')
92: and paa_chq.assignment_action_id = pai.locking_action_id
93: and pai.locked_action_id=paa.assignment_action_id