APPS.PER_KR_EXTRA_AEI_RULES dependencies on PAY_KR_CONTACT_V

Line 128: from pay_kr_contact_v

124: cursor csr_cont_rel_id is
125: select contact_relationship_id, national_identifier,
126: decode(nvl(cont_information11,decode(contact_type, 'S','3','P','1','B','5','SISTER','5',
127: 'A','4','C','4','R','4','O','4','T','4','6')),'1','4','2','4','5','5','4','3','3','2','7','3','6') code -- Bug 12714266
128: from pay_kr_contact_v
129: where assignment_id = p_assignment_id;
130: --
131: cursor csr_cei_exists(p_cont_rel_id in number,p_effective_date in date) is
132: select cei.contact_extra_info_id,

Line 407: from pay_kr_contact_v

403: cursor csr_cont_rel_id is
404: select contact_relationship_id, national_identifier,
405: decode(nvl(cont_information11,decode(contact_type, 'S','3','P','1','B','5','SISTER','5',
406: 'A','4','C','4','R','4','O','4','T','4','6')),'1','4','2','4','5','5','4','3','3','2','7','3','6') code -- Bug 12714266
407: from pay_kr_contact_v
408: where assignment_id = p_assignment_id_o;
409: --
410: cursor csr_cei_exists(p_cont_rel_id in number,p_effective_date in date) is
411: select cei.contact_extra_info_id,

Line 750: from pay_kr_contact_v pkc

746: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
747: --
748: cursor csr_cont_rel_id is
749: select distinct pkc.contact_relationship_id, pkc.national_identifier
750: from pay_kr_contact_v pkc
751: where pkc.assignment_id = p_assignment_id;
752: --
753: cursor csr_cei_exists(p_cont_rel_id in number,p_effective_date in date) is
754: select cei.contact_extra_info_id,

Line 1020: from pay_kr_contact_v pkc

1016: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1017: --
1018: cursor csr_cont_rel_id is
1019: select distinct contact_relationship_id, national_identifier
1020: from pay_kr_contact_v pkc
1021: where pkc.assignment_id = p_assignment_id_o;
1022: --
1023: cursor csr_cei_exists(p_cont_rel_id in number,p_effective_date in date) is
1024: select cei.contact_extra_info_id,

Line 1346: from pay_kr_contact_v

1342: cursor csr_cont_rel_id is
1343: select contact_relationship_id, national_identifier,
1344: nvl(cont_information11,decode(contact_type,'P','1','S','3',
1345: 'A','4','C','4','R','4','O','4','T','4','BROTHER','5','SISTER','5','6') ) code
1346: from pay_kr_contact_v
1347: where assignment_id = p_assignment_id;
1348: --
1349: cursor csr_cei_exists(p_cont_rel_id in number,p_effective_date in date) is
1350: select cei.contact_extra_info_id,

Line 1632: from pay_kr_contact_v

1628: cursor csr_cont_rel_id is
1629: select contact_relationship_id, national_identifier,
1630: nvl(cont_information11,decode(contact_type,'P','1','S','3',
1631: 'A','4','C','4','R','4','O','4','T','4','BROTHER','5','SISTER','5','6')) code
1632: from pay_kr_contact_v
1633: where assignment_id = p_assignment_id_o;
1634: --
1635: cursor csr_cei_exists(p_cont_rel_id in number,p_effective_date in date) is
1636: select cei.contact_extra_info_id,