DBA Data[Home] [Help]

APPS.PAY_FR_PAY_FILE dependencies on PAY_PAYROLL_ACTIONS

Line 35: from pay_payroll_actions ppa

31: to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS'),
32: 'ORG_PAY_METHOD_ID=C', /* Context value for DB items */
33: ppa.org_payment_method_id,
34: 'BUSINESS_GROUP_ID=C', ppa.business_group_id
35: from pay_payroll_actions ppa
36: where ppa.payroll_action_id =
37: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
38:
39:

Line 55: pay_payroll_actions ppa

51: from per_assignments_f pa,
52: per_people_f per,
53: pay_pre_payments ppp,
54: pay_assignment_actions paa,
55: pay_payroll_actions ppa
56: where paa.payroll_action_id =
57: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
58: and paa.pre_payment_id = ppp.pre_payment_id
59: and paa.payroll_action_id = ppa.payroll_action_id