APPS.PAY_JP_REPORT_PKG dependencies on PER_JP_SI_DEPENDENT_TRANSFER_V

Line 1652: SELECT 1 FROM per_jp_si_dependent_transfer_v

1648: p_person_id per_all_people_f.person_id%TYPE,
1649: p_qualified_date DATE) RETURN NUMBER IS
1650: --
1651: CURSOR cel_added IS
1652: SELECT 1 FROM per_jp_si_dependent_transfer_v
1653: WHERE person_id = p_person_id
1654: AND dependent_type IN ('S', 'D')
1655: AND transfer_type = 'I'
1656: AND TRUNC(transfer_date) <> p_qualified_date;

Line 1659: SELECT 2 FROM per_jp_si_dependent_transfer_v

1655: AND transfer_type = 'I'
1656: AND TRUNC(transfer_date) <> p_qualified_date;
1657: --
1658: CURSOR cel_hi_removed IS
1659: SELECT 2 FROM per_jp_si_dependent_transfer_v
1660: WHERE person_id = p_person_id
1661: AND dependent_type IN ('S', 'D')
1662: AND transfer_type = 'E';
1663: --

Line 1665: SELECT 4 FROM per_jp_si_dependent_transfer_v

1661: AND dependent_type IN ('S', 'D')
1662: AND transfer_type = 'E';
1663: --
1664: CURSOR cel_np_added IS
1665: SELECT 4 FROM per_jp_si_dependent_transfer_v
1666: WHERE person_id = p_person_id
1667: AND dependent_type = '3'
1668: AND transfer_type = 'I'
1669: AND TRUNC(transfer_date) <> p_qualified_date;

Line 1672: SELECT 8 FROM per_jp_si_dependent_transfer_v

1668: AND transfer_type = 'I'
1669: AND TRUNC(transfer_date) <> p_qualified_date;
1670: --
1671: CURSOR cel_np_removed IS
1672: SELECT 8 FROM per_jp_si_dependent_transfer_v
1673: WHERE person_id = p_person_id
1674: AND dependent_type = '3'
1675: AND transfer_type = 'E'
1676: AND type3_disqualified_notice = 'Y';

Line 1741: FROM per_jp_si_dependent_transfer_v

1737: p_report_type hr_lookups.lookup_code%TYPE) RETURN DATE IS
1738: --
1739: CURSOR cel_max_effective_date IS
1740: SELECT transfer_date
1741: FROM per_jp_si_dependent_transfer_v
1742: WHERE person_id = p_person_id
1743: AND DECODE(transfer_type, 'I', transfer_date, 'E', transfer_date + 1) BETWEEN p_date_from AND p_date_to
1744: AND (p_report_type = '0'
1745: OR (p_report_type = '10'