APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_PEOPLE_GROUPS

Line 1019: pay_people_groups PEOPLE_GROUP

1015: people_group.segment28,
1016: people_group.segment29,
1017: people_group.segment30
1018: from pay_element_links_f LINK,
1019: pay_people_groups PEOPLE_GROUP
1020: where link.people_group_id = people_group.people_group_id(+)
1021: and link.element_type_id = p_element_type_id
1022: and link.element_link_id <> nvl(p_element_link_id,0)
1023: and link.business_group_id + 0 = p_business_group_id

Line 1072: pay_people_groups PEOPLE_GROUP

1068: people_group.segment28,
1069: people_group.segment29,
1070: people_group.segment30
1071: from pay_batch_element_links BEL,
1072: pay_people_groups PEOPLE_GROUP
1073: where bel.people_group_id = people_group.people_group_id(+)
1074: and bel.element_type_id = p_element_type_id
1075: and bel.batch_element_link_id <> nvl(p_element_link_id,0)
1076: and bel.element_link_id is null

Line 1086: from pay_people_groups

1082: --
1083: cursor csr_my_people_group is
1084: -- Segments of people group for the link being tested
1085: select *
1086: from pay_people_groups
1087: where people_group_id = p_people_group_id;
1088: --
1089: new_link csr_my_people_group%rowtype;
1090: v_last_exclusive_date date;