APPS.PAY_HK_IR56 dependencies on PAY_HK_IR56_QUARTERS_ACTIONS_V

Line 383: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)

379: * Bug 4864213 - Added the following function get_quarters_start_date to return the quaters start date
380: */
381:
382: FUNCTION get_quarters_start_date(p_assignment_id in per_assignments_f.assignment_id%TYPE,
383: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
384: RETURN DATE IS
385:
386: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;
387:

Line 386: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;

382: FUNCTION get_quarters_start_date(p_assignment_id in per_assignments_f.assignment_id%TYPE,
383: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
384: RETURN DATE IS
385:
386: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;
387:
388: CURSOR csr_get_quarters_start_date
389: IS
390: select min(start_date)

Line 391: from pay_hk_ir56_quarters_actions_v

387:
388: CURSOR csr_get_quarters_start_date
389: IS
390: select min(start_date)
391: from pay_hk_ir56_quarters_actions_v
392: where assignment_id = p_assignment_id
393: and l_source_id = p_source_id;
394:
395: BEGIN