APPS.PAY_US_NACHA_IAT_TAPE dependencies on PAY_PAYROLLS_F

Line 110: g_payroll_id PAY_PAYROLLS_F.PAYROLL_ID%TYPE;

106: g_org_sec_code varchar2(3) := null;
107: g_addenda_num NUMBER :=0;
108: g_foreign_transact varchar2(1) := null;
109:
110: g_payroll_id PAY_PAYROLLS_F.PAYROLL_ID%TYPE;
111: g_organization_id per_all_assignments.ORGANIZATION_ID%TYPE;
112: g_full_name per_all_people_f.full_name%type;
113: g_org_name hr_organization_units.name%type;
114: g_street_address hr_locations.ADDRESS_LINE_1%type;

Line 145: pay_payrolls_f pay,

141: ppa.payroll_id
142: from pay_org_payment_methods_f opm,
143: pay_payment_types pt,
144: pay_org_pay_method_usages_f opmu,
145: pay_payrolls_f pay,
146: pay_payroll_actions ppa
147: where ppa.PAYROLL_ACTION_ID = p_payroll_action_id
148: and ppa.payroll_id = pay.payroll_id
149: and ppa.CONSOLIDATION_SET_ID = pay.CONSOLIDATION_SET_ID