APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on HZ_CONTACT_POINTS

Line 1550: FROM hz_contact_points

1546:
1547:
1548: CURSOR l_email_csr (p_owner_table_id IN NUMBER) IS
1549: SELECT email_address
1550: FROM hz_contact_points
1551: WHERE owner_table_name = 'HZ_PARTIES'
1552: AND owner_table_id = p_owner_table_id
1553: AND contact_point_type = 'EMAIL'
1554: AND primary_flag = 'Y'

Line 1571: FROM hz_contact_points t

1567: FROM (SELECT t.contact_point_id,
1568: t.primary_flag,
1569: t.phone_line_type,
1570: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
1571: FROM hz_contact_points t
1572: WHERE t.owner_table_name = 'HZ_PARTIES'
1573: AND t.owner_table_id = p_owner_table_id
1574: AND t.contact_point_type = 'PHONE'
1575: AND t.phone_line_type = 'GEN'

Line 1586: FROM hz_contact_points t

1582: FROM (SELECT t.contact_point_id,
1583: t.primary_flag,
1584: t.phone_line_type,
1585: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
1586: FROM hz_contact_points t
1587: WHERE t.owner_table_name = 'HZ_PARTIES'
1588: AND t.owner_table_id = p_owner_table_id
1589: AND t.contact_point_type = 'PHONE'
1590: AND t.phone_line_type = 'FAX'

Line 1597: FROM hz_contact_points

1593:
1594:
1595: CURSOR l_web_csr (p_owner_table_id IN NUMBER) IS
1596: SELECT url
1597: FROM hz_contact_points
1598: WHERE owner_table_name = 'HZ_PARTIES'
1599: AND owner_table_id = p_owner_table_id
1600: AND contact_point_type = 'WEB'
1601: AND primary_flag = 'Y'

Line 1708: FROM hz_contact_points

1704: WHERE payment_id = p_payment_id;
1705:
1706: CURSOR l_email_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
1707: SELECT email_address
1708: FROM hz_contact_points
1709: WHERE owner_table_name = p_owner_table_name
1710: AND owner_table_id = p_owner_table_id
1711: AND contact_point_type = 'EMAIL'
1712: AND primary_flag = 'Y'

Line 1730: FROM hz_contact_points t

1726: FROM (SELECT t.contact_point_id,
1727: t.primary_flag,
1728: t.phone_line_type,
1729: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
1730: FROM hz_contact_points t
1731: WHERE t.owner_table_name = p_owner_table_name
1732: AND t.owner_table_id = p_owner_table_id
1733: AND t.contact_point_type = 'PHONE'
1734: AND t.phone_line_type = 'GEN'

Line 1745: FROM hz_contact_points t

1741: FROM (SELECT t.contact_point_id,
1742: t.primary_flag,
1743: t.phone_line_type,
1744: RANK() OVER (PARTITION BY t.phone_line_type ORDER BY t.primary_flag DESC, t.contact_point_id DESC) primary_phone
1745: FROM hz_contact_points t
1746: WHERE t.owner_table_name = p_owner_table_name
1747: AND t.owner_table_id = p_owner_table_id
1748: AND t.contact_point_type = 'PHONE'
1749: AND t.phone_line_type = 'FAX'

Line 1755: FROM hz_contact_points

1751: WHERE x.primary_phone = 1;
1752:
1753: CURSOR l_web_csr (p_owner_table_name IN VARCHAR2, p_owner_table_id IN NUMBER) IS
1754: SELECT url
1755: FROM hz_contact_points
1756: WHERE owner_table_name = p_owner_table_name
1757: AND owner_table_id = p_owner_table_id
1758: AND contact_point_type = 'WEB'
1759: AND primary_flag = 'Y'