APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_PEOPLE_F

Line 17: national_identifier per_people_f.national_identifier%TYPE,

13: --
14: -- NI Component Global Variables.
15: --
16: type ni is record(
17: national_identifier per_people_f.national_identifier%TYPE,
18: sex varchar2(1),
19: date_of_birth date);
20: g_ni ni;
21: --------------------------------------------------------------------------------

Line 314: from per_people_f per,

310: is
311: cursor csr_ni is
312: select
313: hr_ni_chk_pkg.chk_nat_id_format(per.national_identifier, 'DDDDDD-DDDDDDD') NI
314: from per_people_f per,
315: per_assignments_f asg
316: where asg.assignment_id = p_assignment_id
317: and per.person_id = asg.person_id
318: and p_effective_date between per.effective_start_date and per.effective_end_date

Line 664: from per_people_f pap

660: l_exception_flag per_people_extra_info.pei_information1%TYPE;
661: --
662: cursor csr_exception_flag is
663: select pei.pei_information1
664: from per_people_f pap
665: ,per_people_extra_info pei
666: ,per_assignments_f paa
667: where paa.assignment_id = p_assignment_id
668: and paa.business_group_id = p_business_group_id

Line 959: from per_people_f per,

955: --
956: cursor csr_new_born is
957: select
958: nvl(cei.cei_information13, 'N')
959: from per_people_f per,
960: per_contact_relationships ctr,
961: per_assignments_f asg,
962: per_contact_extra_info_f cei
963: where asg.assignment_id = p_assignment_id

Line 986: from per_people_f per2

982: (
983: per.start_date = per.effective_start_date
984: and not exists(
985: select null
986: from per_people_f per2
987: where per2.person_id = per.person_id
988: and p_date_earned
989: between per2.effective_start_date and per2.effective_end_date)
990: )

Line 1126: from per_people_f per,

1122: decode(ctr.cont_information7, 'Y', child_flag(ctr.cont_information11,ctr.contact_type,per.national_identifier, p_date_earned), 'N') CHILD_FLAG,
1123: -- Bug 6784288; Bug 6825145; Bug 7615517
1124: decode(ctr.cont_information2, 'Y', decode(addtl_child_flag(ctr.contact_type, per.national_identifier, ctr.cont_information4, ctr.cont_information11, ctr.cont_information15, p_date_earned),'Y','Y','N'), 'N') ADDTL_CHILD,
1125: decode(ctr.cont_information2, 'Y', single_parent_child_flag(ctr.cont_information11,ctr.contact_type,per.national_identifier, p_date_earned), 'N') SINGLE_PARENT_CHILD_FLAG
1126: from per_people_f per,
1127: per_contact_relationships ctr,
1128: per_assignments_f asg
1129: where asg.assignment_id = p_assignment_id
1130: and p_date_earned

Line 1149: from per_people_f per2

1145: (
1146: per.start_date = per.effective_start_date
1147: and not exists(
1148: select null
1149: from per_people_f per2
1150: where per2.person_id = per.person_id
1151: and p_date_earned
1152: between per2.effective_start_date and per2.effective_end_date)
1153: )

Line 1165: from per_people_f per,

1161: disabled_flag(per.person_id, p_date_earned) DISABLED_FLAG,
1162: child_flag('0','E',per.national_identifier, p_date_earned) CHILD_FLAG,
1163: nvl(pei.pei_information3,'N') FEMALE_EMP_DOC,
1164: super_aged_flag(per.national_identifier, p_date_earned) SUPER_AGED_FLAG -- Bug 4124430
1165: from per_people_f per,
1166: per_assignments_f asg,
1167: per_people_extra_info pei
1168: where asg.assignment_id = p_assignment_id
1169: and p_date_earned

Line 1332: ,per_people_f pp

1328: is
1329: select pei_information8 loss_code
1330: ,pei_information9 loss_date
1331: from per_people_extra_info pei
1332: ,per_people_f pp
1333: ,per_assignments_f paa
1334: ,per_time_periods ptp
1335: where paa.assignment_id = p_assignment_id
1336: and paa.business_group_id = p_business_group_id

Line 1429: p_ni in per_people_f.national_identifier%type,

1425: --
1426: function is_exempted_dependent(
1427: p_cont_type in per_contact_relationships.contact_type%type,
1428: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,

Line 1599: p_ni in per_people_f.national_identifier%type,

1595: --
1596: function dpnt_eligible_for_basic_exem(
1597: p_cont_type in per_contact_relationships.contact_type%type,
1598: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1603: p_eff_date in pay_payroll_actions.effective_date%type