APPS.HR_ASSIGNMENT dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2374: PAY_PERSONAL_PAYMENT_METHODS_F

2370: PER_EVENTS
2371: PER_LETTER_REQUEST_LINES
2372: PAY_COST_ALLOCATIONS_F
2373: PER_ASSIGNMENT_EXTRA_INFO
2374: PAY_PERSONAL_PAYMENT_METHODS_F
2375: HR_ASSIGNMENT_SET_AMENDMENTS
2376: PAY_ASSIGNMENT_ACTIONS
2377: PER_COBRA_COV_ENROLLMENTS
2378: PER_COBRA_COVERAGE_BENEFITS_F

Line 2385: PAY_PERSONAL_PAYMENT_METHODS_F

2381: For 'END' (date effective delete)
2382: PER_EVENTS
2383: PER_LETTER_REQUEST_LINES
2384: PAY_COST_ALLOCATIONS_F
2385: PAY_PERSONAL_PAYMENT_METHODS_F
2386: PAY_ASSIGNMENT_ACTIONS
2387: PER_COBRA_COV_ENROLLMENTS
2388: PER_COBRA_COVERAGE_BENEFITS_F
2389:

Line 2583: from PAY_PERSONAL_PAYMENT_METHODS_F

2579: into p_del_flag
2580: from sys.dual
2581: where exists (
2582: select null
2583: from PAY_PERSONAL_PAYMENT_METHODS_F
2584: where assignment_id = p_assignment_id
2585: and (p_mode = 'ZAP'
2586: or (p_mode = 'END'
2587: and effective_start_date > p_end_date)));

Line 3625: PAY_PERSONAL_PAYMENT_METHODS_F

3621: The following tables are affected.
3622:
3623: PAY_COST_ALLOCATIONS_F
3624: PER_SECONDARY_ASS_STATUSES
3625: PAY_PERSONAL_PAYMENT_METHODS_F
3626: PER_ASSIGNMENT_BUDGET_VALUES_F
3627:
3628: PARAMETERS
3629: p_assignment_id - Assignment ID

Line 3946: from pay_personal_payment_methods_f ppm

3942: --retrieve all the current PPMs
3943: --
3944: cursor csr_curr_ppm is
3945: select ppm.personal_payment_method_id,ppm.object_version_number
3946: from pay_personal_payment_methods_f ppm
3947: where ppm.assignment_id = p_assignment_id
3948: and p_new_end_date between ppm.effective_start_date and ppm.effective_end_date
3949: and p_mode='END';
3950: --

Line 3955: from pay_personal_payment_methods_f ppm

3951: --retrieve all the future-only PPMs
3952: --
3953: cursor csr_fut_ppm is
3954: select ppm.personal_payment_method_id,ppm.object_version_number,ppm.effective_start_date
3955: from pay_personal_payment_methods_f ppm
3956: where ppm.assignment_id = p_assignment_id
3957: and p_new_end_date < ppm.effective_start_date
3958: and p_mode='END';
3959: --