APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 109: FROM pay_personal_payment_methods_f ppm

105: ) RETURN VARCHAR2 IS
106: --
107: CURSOR csr_get_payee_type_id IS
108: SELECT payee_type,payee_id
109: FROM pay_personal_payment_methods_f ppm
110: WHERE ppm.assignment_id = p_assignment_id
111: AND ppm.personal_payment_method_id = p_per_pay_method_id
112: AND p_date_earned BETWEEN ppm.effective_start_date
113: AND ppm.effective_end_date

Line 117: cursor csr_org_count (p_org_id pay_personal_payment_methods_f.payee_id%TYPE) is

113: AND ppm.effective_end_date
114: AND ppm.business_group_id = p_business_group_id
115: AND ppm.payee_id is NOT NULL;
116: --
117: cursor csr_org_count (p_org_id pay_personal_payment_methods_f.payee_id%TYPE) is
118: select count(*) from
119: hr_All_organization_units hou,
120: hr_organization_information hoi
121: where hou.organization_id = p_org_id

Line 127: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;

123: and hoi.org_information_context = 'CLASS'
124: and hoi.org_information1 = 'NL_PAYEE_OVERRIDE'
125: and hoi.org_information2='Y';
126: --
127: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
128: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
129: l_payee_name VARCHAR(35);
130: l_org_count NUMBER;
131: --

Line 128: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;

124: and hoi.org_information1 = 'NL_PAYEE_OVERRIDE'
125: and hoi.org_information2='Y';
126: --
127: l_payee_type pay_personal_payment_methods_f.payee_type%TYPE;
128: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
129: l_payee_name VARCHAR(35);
130: l_org_count NUMBER;
131: --
132: l_inputs ff_exec.inputs_t;

Line 620: ,pay_personal_payment_methods_f ppmf

616: ,pay_all_payrolls_f ppf
617: ,pay_pre_payments ppp
618: ,pay_assignment_actions paa
619: ,pay_payroll_actions ppa
620: ,pay_personal_payment_methods_f ppmf
621: ,pay_external_accounts pea
622: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
623: AND paa.pre_payment_id = ppp.pre_payment_id
624: AND paa.payroll_action_id = ppa.payroll_action_id