DBA Data[Home] [Help]

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1503: ,pay_personal_payment_methods_f ppm

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
1507: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)

Line 1551: l_percentage pay_personal_payment_methods_f.percentage%TYPE;

1547: l_bank_name pay_external_accounts.segment3%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;