APPS.HR_ASSIGNMENT dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2411: PAY_PERSONAL_PAYMENT_METHODS_F

2407: PER_EVENTS
2408: PER_LETTER_REQUEST_LINES
2409: PAY_COST_ALLOCATIONS_F
2410: PER_ASSIGNMENT_EXTRA_INFO
2411: PAY_PERSONAL_PAYMENT_METHODS_F
2412: HR_ASSIGNMENT_SET_AMENDMENTS
2413: PAY_ASSIGNMENT_ACTIONS
2414: PER_COBRA_COV_ENROLLMENTS
2415: PER_COBRA_COVERAGE_BENEFITS_F

Line 2422: PAY_PERSONAL_PAYMENT_METHODS_F

2418: For 'END' (date effective delete)
2419: PER_EVENTS
2420: PER_LETTER_REQUEST_LINES
2421: PAY_COST_ALLOCATIONS_F
2422: PAY_PERSONAL_PAYMENT_METHODS_F
2423: PAY_ASSIGNMENT_ACTIONS
2424: PER_COBRA_COV_ENROLLMENTS
2425: PER_COBRA_COVERAGE_BENEFITS_F
2426:

Line 2620: from PAY_PERSONAL_PAYMENT_METHODS_F

2616: into p_del_flag
2617: from sys.dual
2618: where exists (
2619: select null
2620: from PAY_PERSONAL_PAYMENT_METHODS_F
2621: where assignment_id = p_assignment_id
2622: and (p_mode = 'ZAP'
2623: or (p_mode = 'END'
2624: and effective_start_date > p_end_date)));

Line 3665: PAY_PERSONAL_PAYMENT_METHODS_F

3661: The following tables are affected.
3662:
3663: PAY_COST_ALLOCATIONS_F
3664: PER_SECONDARY_ASS_STATUSES
3665: PAY_PERSONAL_PAYMENT_METHODS_F
3666: PER_ASSIGNMENT_BUDGET_VALUES_F
3667:
3668: PARAMETERS
3669: p_assignment_id - Assignment ID

Line 3986: from pay_personal_payment_methods_f ppm

3982: --retrieve all the current PPMs
3983: --
3984: cursor csr_curr_ppm is
3985: select ppm.personal_payment_method_id,ppm.object_version_number
3986: from pay_personal_payment_methods_f ppm
3987: where ppm.assignment_id = p_assignment_id
3988: and p_new_end_date between ppm.effective_start_date and ppm.effective_end_date
3989: and p_mode='END';
3990: --

Line 3995: from pay_personal_payment_methods_f ppm

3991: --retrieve all the future-only PPMs
3992: --
3993: cursor csr_fut_ppm is
3994: select ppm.personal_payment_method_id,ppm.object_version_number,ppm.effective_start_date
3995: from pay_personal_payment_methods_f ppm
3996: where ppm.assignment_id = p_assignment_id
3997: and p_new_end_date < ppm.effective_start_date
3998: and p_mode='END';
3999: --