APPS.PER_ASG_BUS2 dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 267: pay_personal_payment_methods_f.org_payment_method_id%TYPE;

263: l_min_ppm_effective_start_date date;
264: l_max_opu_effective_end_date date;
265: l_max_ppm_effective_end_date date;
266: l_org_payment_method_id
267: pay_personal_payment_methods_f.org_payment_method_id%TYPE;
268: l_org_pay_method_usage_id
269: pay_org_pay_method_usages_f.org_pay_method_usage_id%TYPE;
270: l_personal_payment_method_id
271: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

Line 271: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;

267: pay_personal_payment_methods_f.org_payment_method_id%TYPE;
268: l_org_pay_method_usage_id
269: pay_org_pay_method_usages_f.org_pay_method_usage_id%TYPE;
270: l_personal_payment_method_id
271: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
272: l_proc varchar2(72) := g_package||'chk_payroll_id_int';
273: l_working_start_date date;
274: l_working_end_date date;
275:

Line 305: from pay_personal_payment_methods_f ppm

301: select ppm.personal_payment_method_id
302: ,ppm.org_payment_method_id
303: ,min(ppm.effective_start_date)
304: ,max(ppm.effective_end_date)
305: from pay_personal_payment_methods_f ppm
306: where ppm.assignment_id = p_assignment_id
307: and ppm.effective_start_date <= p_validation_end_date
308: and ppm.effective_end_date >= p_validation_start_date
309: group by ppm.personal_payment_method_id

Line 3078: -- - PAY_PERSONAL_PAYMENT_METHODS_F

3074: -- - PER_EVENTS
3075: -- - PER_LETTER_REQUEST_LINES
3076: -- - PAY_COST_ALLOCATIONS_F
3077: -- - PAY_PAYROLL_ACTIONS
3078: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3079: -- - PAY_ASSIGNMENT_ACTIONS
3080: -- - PER_COBRA_COV_ENROLLMENTS
3081: -- - PER_COBRA_COVERAGE_BENEFITS_F
3082: -- - PER_ASSIGNMENTS_EXTRA_INFO

Line 3155: from pay_personal_payment_methods_f

3151: cursor csr_pay_pers_payment_methods is
3152: select null
3153: from sys.dual
3154: where exists(select null
3155: from pay_personal_payment_methods_f
3156: where assignment_id = p_assignment_id
3157: and (p_datetrack_mode = 'ZAP'
3158: or (p_datetrack_mode = 'DELETE'
3159: and effective_start_date > p_validation_start_date)));