APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on HR_ASSIGNMENT_SET

Line 780: from hr_assignment_set_amendments hasa

776: or (
777: :cp_assignment_set_id is not NULL
778: and :cp_assignment_set_id in
779: (select assignment_set_id
780: from hr_assignment_set_amendments hasa
781: where hasa.assignment_set_id = :cp_assignment_set_id
782: and pcd.assignment_id = hasa.assignment_id
783: )
784: )

Line 862: from hr_assignment_set_amendments hasa

858: and (:cp_assignment_set_id is NULL
859: or ( :cp_assignment_set_id is not NULL
860: and :cp_assignment_set_id in
861: (select assignment_set_id
862: from hr_assignment_set_amendments hasa
863: where hasa.assignment_set_id = :cp_assignment_set_id
864: and pcd.assignment_id = hasa.assignment_id
865: )
866: )

Line 961: from hr_assignment_set_amendments hasa

957: and (:cp_assignment_set_id is NULL
958: or ( :cp_assignment_set_id is not NULL
959: and :cp_assignment_set_id in
960: (select assignment_set_id
961: from hr_assignment_set_amendments hasa
962: where hasa.assignment_set_id = :cp_assignment_set_id
963: and pcd.assignment_id = hasa.assignment_id
964: )
965: )

Line 1044: from hr_assignment_set_amendments hasa

1040: and (:cp_assignment_set_id is NULL
1041: or ( :cp_assignment_set_id is not NULL
1042: and :cp_assignment_set_id in
1043: (select assignment_set_id
1044: from hr_assignment_set_amendments hasa
1045: where hasa.assignment_set_id = :cp_assignment_set_id
1046: and pcd.assignment_id = hasa.assignment_id
1047: )
1048: )

Line 1174: if hr_assignment_set.assignment_in_set(

1170: ************************************************************/
1171: hr_utility.set_location(gv_package_name || '.costing_extract', 100);
1172: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1173:
1174: if hr_assignment_set.assignment_in_set(
1175: p_assignment_set_id
1176: ,ln_assignment_id) = 'Y' then
1177:
1178: