APPS.PAY_HK_IR56 dependencies on PAY_HK_IR56_QUARTERS_ACTIONS_V

Line 433: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)

429: * Bug 4864213 - Added the following function get_quarters_start_date to return the quaters start date
430: */
431:
432: FUNCTION get_quarters_start_date(p_assignment_id in per_assignments_f.assignment_id%TYPE,
433: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
434: RETURN DATE IS
435:
436: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;
437:

Line 436: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;

432: FUNCTION get_quarters_start_date(p_assignment_id in per_assignments_f.assignment_id%TYPE,
433: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
434: RETURN DATE IS
435:
436: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;
437:
438: CURSOR csr_get_quarters_start_date
439: IS
440: select min(start_date)

Line 441: from pay_hk_ir56_quarters_actions_v

437:
438: CURSOR csr_get_quarters_start_date
439: IS
440: select min(start_date)
441: from pay_hk_ir56_quarters_actions_v
442: where assignment_id = p_assignment_id
443: and l_source_id = p_source_id;
444:
445: BEGIN