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 789: hr_assignment_sets has

785: CURSOR csr_get_flag_from_set
786: IS
787: SELECT DISTINCT hasa.include_or_exclude FROM
788: hr_assignment_set_amendments hasa,
789: hr_assignment_sets has
790: WHERE hasa.assignment_set_id = has.assignment_set_id
791: AND has.business_group_id = l_bg_id
792: AND has.assignment_set_id = l_assignment_set_id;
793:

Line 879: , hr_assignment_sets has

875: --and check_assignment_in_set(asg.assignment_id,l_assignment_set_id,l_bg_id)=1
876: AND ((l_assignment_set_id is not null
877: AND (l_set_flag ='I' AND EXISTS(SELECT 1
878: FROM hr_assignment_set_amendments hasa
879: , hr_assignment_sets has
880: , per_assignments_f paf
881: -- , pay_all_payrolls_f pay
882: -- , hr_soft_coding_keyflex hflex
883: WHERE has.assignment_set_id = hasa.assignment_set_id

Line 893: , hr_assignment_sets has

889: --AND pay.soft_coding_keyflex_id = hflex.soft_coding_keyflex_id
890: --AND hflex.segment4 = l_segment4)
891: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
892: FROM hr_assignment_set_amendments hasa
893: , hr_assignment_sets has
894: , per_assignments_f paf
895: -- , pay_all_payrolls_f pay
896: -- , hr_soft_coding_keyflex hflex
897: WHERE has.assignment_set_id = hasa.assignment_set_id

Line 5676: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,

5672: END get_end_date;
5673:
5674: Function check_assignment_in_set(
5675: p_assignment_id per_assignments_f.assignment_id%TYPE,
5676: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,
5677: p_business_group per_assignments_f.business_group_id%TYPE
5678: ) return NUMBER
5679: AS
5680: CURSOR csr_locked_asg_sets

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

5678: ) return NUMBER
5679: AS
5680: CURSOR csr_locked_asg_sets
5681: is
5682: select hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
5683: where hasa.assignment_set_id = has.assignment_set_id
5684: and has.business_group_id = p_business_group
5685: and has.assignment_set_id = p_assignment_set_id
5686: and hasa.assignment_id = p_assignment_id;

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

5685: and has.assignment_set_id = p_assignment_set_id
5686: and hasa.assignment_id = p_assignment_id;
5687: CURSOR csr_get_flag_from_set
5688: is
5689: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
5690: where hasa.assignment_set_id = has.assignment_set_id
5691: and has.business_group_id = p_business_group
5692: and has.assignment_set_id = p_assignment_set_id;
5693: l_set_flag Varchar2(30) :=null;