APPS.PAY_JP_REPORT_PKG dependencies on PER_JP_SI_DEPENDENT_TRANSFER_V

Line 1643: SELECT 1 FROM per_jp_si_dependent_transfer_v

1639: p_person_id per_all_people_f.person_id%TYPE,
1640: p_qualified_date DATE) RETURN NUMBER IS
1641: --
1642: CURSOR cel_added IS
1643: SELECT 1 FROM per_jp_si_dependent_transfer_v
1644: WHERE person_id = p_person_id
1645: AND dependent_type IN ('S', 'D')
1646: AND transfer_type = 'I'
1647: AND TRUNC(transfer_date) <> p_qualified_date;

Line 1650: SELECT 2 FROM per_jp_si_dependent_transfer_v

1646: AND transfer_type = 'I'
1647: AND TRUNC(transfer_date) <> p_qualified_date;
1648: --
1649: CURSOR cel_hi_removed IS
1650: SELECT 2 FROM per_jp_si_dependent_transfer_v
1651: WHERE person_id = p_person_id
1652: AND dependent_type IN ('S', 'D')
1653: AND transfer_type = 'E';
1654: --

Line 1656: SELECT 4 FROM per_jp_si_dependent_transfer_v

1652: AND dependent_type IN ('S', 'D')
1653: AND transfer_type = 'E';
1654: --
1655: CURSOR cel_np_added IS
1656: SELECT 4 FROM per_jp_si_dependent_transfer_v
1657: WHERE person_id = p_person_id
1658: AND dependent_type = '3'
1659: AND transfer_type = 'I'
1660: AND TRUNC(transfer_date) <> p_qualified_date;

Line 1663: SELECT 8 FROM per_jp_si_dependent_transfer_v

1659: AND transfer_type = 'I'
1660: AND TRUNC(transfer_date) <> p_qualified_date;
1661: --
1662: CURSOR cel_np_removed IS
1663: SELECT 8 FROM per_jp_si_dependent_transfer_v
1664: WHERE person_id = p_person_id
1665: AND dependent_type = '3'
1666: AND transfer_type = 'E'
1667: AND type3_disqualified_notice = 'Y';

Line 1732: FROM per_jp_si_dependent_transfer_v

1728: p_report_type hr_lookups.lookup_code%TYPE) RETURN DATE IS
1729: --
1730: CURSOR cel_max_effective_date IS
1731: SELECT transfer_date
1732: FROM per_jp_si_dependent_transfer_v
1733: WHERE person_id = p_person_id
1734: AND DECODE(transfer_type, 'I', transfer_date, 'E', transfer_date + 1) BETWEEN p_date_from AND p_date_to
1735: AND (p_report_type = '0'
1736: OR (p_report_type = '10'