APPS.PAY_IE_P35 dependencies on HR_ASSIGNMENT_SETS

Line 32: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

28: l_start_date DATE;
29: l_end_date DATE;
30: l_bg_id NUMBER;
31: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
32: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
33: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
34:
35:
36: -- declaring the pl/sql table for storing the first 5 contribution class values

Line 796: hr_assignment_sets has

792: CURSOR csr_get_flag_from_set
793: IS
794: SELECT DISTINCT hasa.include_or_exclude FROM
795: hr_assignment_set_amendments hasa,
796: hr_assignment_sets has
797: WHERE hasa.assignment_set_id = has.assignment_set_id
798: AND has.business_group_id = l_bg_id
799: AND has.assignment_set_id = l_assignment_set_id;
800:

Line 887: , hr_assignment_sets has

883: --and check_assignment_in_set(asg.assignment_id,l_assignment_set_id,l_bg_id)=1
884: AND ((l_assignment_set_id is not null
885: AND (l_set_flag ='I' AND EXISTS(SELECT 1
886: FROM hr_assignment_set_amendments hasa
887: , hr_assignment_sets has
888: , per_assignments_f paf
889: -- , pay_all_payrolls_f pay
890: -- , hr_soft_coding_keyflex hflex
891: WHERE has.assignment_set_id = hasa.assignment_set_id

Line 901: , hr_assignment_sets has

897: --AND pay.soft_coding_keyflex_id = hflex.soft_coding_keyflex_id
898: --AND hflex.segment4 = l_segment4)
899: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
900: FROM hr_assignment_set_amendments hasa
901: , hr_assignment_sets has
902: , per_assignments_f paf
903: -- , pay_all_payrolls_f pay
904: -- , hr_soft_coding_keyflex hflex
905: WHERE has.assignment_set_id = hasa.assignment_set_id

Line 8947: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,

8943: END get_end_date;
8944:
8945: Function check_assignment_in_set(
8946: p_assignment_id per_assignments_f.assignment_id%TYPE,
8947: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,
8948: p_business_group per_assignments_f.business_group_id%TYPE
8949: ) return NUMBER
8950: AS
8951: CURSOR csr_locked_asg_sets

Line 8953: select hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has

8949: ) return NUMBER
8950: AS
8951: CURSOR csr_locked_asg_sets
8952: is
8953: select hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
8954: where hasa.assignment_set_id = has.assignment_set_id
8955: and has.business_group_id = p_business_group
8956: and has.assignment_set_id = p_assignment_set_id
8957: and hasa.assignment_id = p_assignment_id;

Line 8960: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has

8956: and has.assignment_set_id = p_assignment_set_id
8957: and hasa.assignment_id = p_assignment_id;
8958: CURSOR csr_get_flag_from_set
8959: is
8960: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
8961: where hasa.assignment_set_id = has.assignment_set_id
8962: and has.business_group_id = p_business_group
8963: and has.assignment_set_id = p_assignment_set_id;
8964: l_set_flag Varchar2(30) :=null;