DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1502: ,pay_org_payment_methods_f pop

1498: ,ppm.percentage percentage
1499: ,pop.currency_code
1500: FROM pay_external_accounts pea
1501: ,pay_pre_payments ppp
1502: ,pay_org_payment_methods_f pop
1503: ,pay_personal_payment_methods_f ppm
1504: WHERE ppp.assignment_action_id = p_curr_pymt_ass_act_id
1505: AND nvl(ppp.personal_payment_method_id,0) = nvl(p_personal_payment_method_id,0)
1506: AND ppp.org_payment_method_id = p_org_payment_method_id

Line 1552: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;

1548: l_bank_branch pay_external_accounts.segment4%TYPE;
1549: l_bank VARCHAR2(310);
1550: l_account_number pay_external_accounts.segment1%TYPE;
1551: l_percentage pay_personal_payment_methods_f.percentage%TYPE;
1552: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
1553: l_prof_tax_number hr_organization_information.org_information1%TYPE;
1554: /*4229709*/
1555: l_emp_det_act_info_id NUMBER;
1556: l_tax_area VARCHAR2(10);