APPS.PAY_NO_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 11: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;

7: PROCEDURE get_main_tax_unit_id
8: (p_assignment_id IN NUMBER
9: ,p_effective_date IN DATE
10: ,p_tax_unit_id OUT NOCOPY NUMBER ) IS
11: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
12: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
13: CURSOR c_local_unit_id IS
14: SELECT SCL.segment2 , business_group_id
15: FROM

Line 17: hr_soft_coding_keyflex SCL

13: CURSOR c_local_unit_id IS
14: SELECT SCL.segment2 , business_group_id
15: FROM
16: per_all_assignments_f PAA ,
17: hr_soft_coding_keyflex SCL
18: WHERE ASSIGNMENT_ID = p_assignment_id
19: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
20: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
21: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS

Line 349: from hr_soft_coding_keyflex scl,

345: p_source_id IN OUT NOCOPY VARCHAR2)
346: IS
347: CURSOR csr_get_local_unit (p_assignment_action_id NUMBER) IS
348: select scl.segment2
349: from hr_soft_coding_keyflex scl,
350: pay_assignment_actions pac,
351: per_all_assignments_f ASSIGN,
352: pay_legislation_rules LEG,
353: fnd_id_flex_structures fstruct

Line 390: from hr_soft_coding_keyflex scl,

386: p_local_unit_id OUT NOCOPY NUMBER)
387: IS
388: CURSOR csr_get_local_unit (p_assignment_id NUMBER) IS
389: select scl.segment2
390: from hr_soft_coding_keyflex scl,
391: per_all_assignments_f ASSIGN,
392: pay_legislation_rules LEG,
393: fnd_id_flex_structures fstruct
394: Where ASSIGN.assignment_id = p_assignment_id

Line 520: hr_soft_coding_keyflex scl ,

516: SELECT ORG_INFORMATION6 lu_tax_mun
517: FROM pay_assignment_actions assact ,
518: per_all_assignments_f paa ,
519: pay_payroll_actions ppa ,
520: hr_soft_coding_keyflex scl ,
521: hr_organization_information hoi
522: WHERE assact.assignment_action_id = p_assignment_action_id
523: AND ppa.payroll_action_id = assact.payroll_action_id
524: AND paa.assignment_id = assact.assignment_id