APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_PEOPLE_GROUPS

Line 1028: pay_people_groups PEOPLE_GROUP

1024: people_group.segment28,
1025: people_group.segment29,
1026: people_group.segment30
1027: from pay_element_links_f LINK,
1028: pay_people_groups PEOPLE_GROUP
1029: where link.people_group_id = people_group.people_group_id(+)
1030: and link.element_type_id = p_element_type_id
1031: and link.element_link_id <> nvl(p_element_link_id,0)
1032: and link.business_group_id + 0 = p_business_group_id

Line 1081: pay_people_groups PEOPLE_GROUP

1077: people_group.segment28,
1078: people_group.segment29,
1079: people_group.segment30
1080: from pay_batch_element_links BEL,
1081: pay_people_groups PEOPLE_GROUP
1082: where bel.people_group_id = people_group.people_group_id(+)
1083: and bel.element_type_id = p_element_type_id
1084: and bel.batch_element_link_id <> nvl(p_element_link_id,0)
1085: and bel.element_link_id is null

Line 1095: from pay_people_groups

1091: --
1092: cursor csr_my_people_group is
1093: -- Segments of people group for the link being tested
1094: select *
1095: from pay_people_groups
1096: where people_group_id = p_people_group_id;
1097: --
1098: new_link csr_my_people_group%rowtype;
1099: v_last_exclusive_date date;