APPS.PAY_AU_PAYMENT_SUMMARY dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 1136: hr_assignment_set_amendments hasa,

1132: cursor cur_inc_exc_flag
1133: is
1134: select distinct hasa.include_or_exclude inc_or_exc
1135: from
1136: hr_assignment_set_amendments hasa,
1137: hr_assignment_sets has
1138: where hasa.assignment_set_id = has.assignment_set_id
1139: and has.business_group_id = g_business_group_id
1140: and has.assignment_set_id = v_assignment_set_id;

Line 1520: ,hr_assignment_set_amendments hasa

1516: ,per_assignments_f a
1517: ,pay_payroll_actions pa
1518: ,per_periods_of_service pps
1519: ,pay_population_ranges ppr
1520: ,hr_assignment_set_amendments hasa
1521: WHERE pa.payroll_action_id = c_payroll_action_id
1522: AND pa.payroll_action_id = ppr.payroll_action_id
1523: AND ppr.payroll_action_id = c_payroll_action_id
1524: AND ppr.chunk_number = c_chunk

Line 1621: ,hr_assignment_set_amendments hasa

1617: from per_people_f p /*Bug3043049*/
1618: ,per_assignments_f a /*Bug3043049*/
1619: ,pay_payroll_actions pa
1620: ,per_periods_of_service pps
1621: ,hr_assignment_set_amendments hasa
1622: where pa.payroll_action_id = c_payroll_action_id
1623: and p.person_id between c_start_person_id and c_end_person_id
1624: and p.person_id = a.person_id
1625: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (v_fin_year_end)),1,'Y','N')) LIKE v_employee_type --Bug#3744930

Line 1869: SELECT count(*) INTO v_count FROM hr_assignment_set_amendments

1865: ,p_chunk)
1866: LOOP
1867:
1868: IF l_cur_inc_exc_flag_rec.inc_or_exc = 'E' THEN
1869: SELECT count(*) INTO v_count FROM hr_assignment_set_amendments
1870: WHERE ASSIGNMENT_SET_ID=v_assignment_set_id AND ASSIGNMENT_ID=csr_rec.assignment_id;
1871: END IF;
1872:
1873: IF (v_count = 0 AND l_cur_inc_exc_flag_rec.inc_or_exc = 'E') OR (v_count = 2)

Line 1901: SELECT count(*) INTO v_count FROM hr_assignment_set_amendments

1897: p_end_person_id)
1898: Loop
1899:
1900: IF l_cur_inc_exc_flag_rec.inc_or_exc = 'E' THEN
1901: SELECT count(*) INTO v_count FROM hr_assignment_set_amendments
1902: WHERE ASSIGNMENT_SET_ID=v_assignment_set_id AND ASSIGNMENT_ID=process_rec.assignment_id;
1903: END IF;
1904:
1905: IF (v_count = 0 AND l_cur_inc_exc_flag_rec.inc_or_exc = 'E') OR (v_count = 2)