APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PER_CONTACT_RELATIONSHIPS

Line 2628: FROM per_contact_relationships ctr, per_all_people_f per

2624: --bug#3274130 - added date condition for relationship to pick the right spouse
2625: CURSOR c_per_spouse IS
2626: SELECT per.person_id
2627: ,per.date_of_birth
2628: FROM per_contact_relationships ctr, per_all_people_f per
2629: WHERE ctr.person_id = p_person_id
2630: AND per.person_id = ctr.contact_person_id
2631: AND ctr.personal_flag = 'Y'
2632: AND ctr.contact_type = 'S'

Line 2641: FROM per_contact_relationships ctr, per_all_people_f per

2637: --
2638: CURSOR c_per_depen_first IS
2639: SELECT per.person_id
2640: ,per.date_of_birth
2641: FROM per_contact_relationships ctr, per_all_people_f per
2642: WHERE ctr.person_id = p_person_id
2643: AND per.person_id = ctr.contact_person_id
2644: AND ctr.personal_flag = 'Y'
2645: AND ctr.dependent_flag = 'Y'

Line 2652: FROM per_contact_relationships ctr, per_all_people_f per

2648: --
2649: CURSOR c_per_child_first IS
2650: SELECT per.person_id
2651: ,per.date_of_birth
2652: FROM per_contact_relationships ctr, per_all_people_f per
2653: WHERE ctr.person_id = p_person_id
2654: AND per.person_id = ctr.contact_person_id
2655: AND ctr.personal_flag = 'Y'
2656: AND ctr.contact_type IN ('C', 'O', 'A', 'T')

Line 2663: FROM per_contact_relationships ctr, per_all_people_f per

2659: --
2660: CURSOR c_per_depen_oldest IS
2661: SELECT per.person_id
2662: ,per.date_of_birth
2663: FROM per_contact_relationships ctr, per_all_people_f per
2664: WHERE ctr.person_id = p_person_id
2665: AND per.person_id = ctr.contact_person_id
2666: AND ctr.personal_flag = 'Y'
2667: AND ctr.dependent_flag = 'Y'

Line 2675: FROM per_contact_relationships ctr, per_all_people_f per

2671: --
2672: CURSOR c_per_child_oldest IS
2673: SELECT per.person_id
2674: ,per.date_of_birth
2675: FROM per_contact_relationships ctr, per_all_people_f per
2676: WHERE ctr.person_id = p_person_id
2677: AND per.person_id = ctr.contact_person_id
2678: AND ctr.personal_flag = 'Y'
2679: AND ctr.contact_type IN ('C', 'O', 'A', 'T')

Line 2687: FROM per_contact_relationships ctr, per_all_people_f per

2683: --
2684: CURSOR c_per_depen_young IS
2685: SELECT per.person_id
2686: ,per.date_of_birth
2687: FROM per_contact_relationships ctr, per_all_people_f per
2688: WHERE ctr.person_id = p_person_id
2689: AND per.person_id = ctr.contact_person_id
2690: AND ctr.personal_flag = 'Y'
2691: AND ctr.dependent_flag = 'Y'

Line 2699: FROM per_contact_relationships ctr, per_all_people_f per

2695: --
2696: CURSOR c_per_child_young IS
2697: SELECT per.person_id
2698: ,per.date_of_birth
2699: FROM per_contact_relationships ctr, per_all_people_f per
2700: WHERE ctr.person_id = p_person_id
2701: AND per.person_id = ctr.contact_person_id
2702: AND ctr.personal_flag = 'Y'
2703: AND ctr.contact_type IN ('C', 'O', 'A', 'T')