APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PER_CONTACT_RELATIONSHIPS

Line 2629: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2642: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2653: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2664: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2676: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2688: FROM per_contact_relationships ctr, per_all_people_f per

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

Line 2700: FROM per_contact_relationships ctr, per_all_people_f per

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