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 355: from hr_soft_coding_keyflex scl,

351: p_source_id IN OUT NOCOPY VARCHAR2)
352: IS
353: CURSOR csr_get_local_unit (p_assignment_action_id NUMBER) IS
354: select scl.segment2
355: from hr_soft_coding_keyflex scl,
356: pay_assignment_actions pac,
357: per_all_assignments_f ASSIGN,
358: pay_legislation_rules LEG,
359: fnd_id_flex_structures fstruct

Line 396: from hr_soft_coding_keyflex scl,

392: p_local_unit_id OUT NOCOPY NUMBER)
393: IS
394: CURSOR csr_get_local_unit (p_assignment_id NUMBER) IS
395: select scl.segment2
396: from hr_soft_coding_keyflex scl,
397: per_all_assignments_f ASSIGN,
398: pay_legislation_rules LEG,
399: fnd_id_flex_structures fstruct
400: Where ASSIGN.assignment_id = p_assignment_id

Line 526: hr_soft_coding_keyflex scl ,

522: SELECT ORG_INFORMATION6 lu_tax_mun
523: FROM pay_assignment_actions assact ,
524: per_all_assignments_f paa ,
525: pay_payroll_actions ppa ,
526: hr_soft_coding_keyflex scl ,
527: hr_organization_information hoi
528: WHERE assact.assignment_action_id = p_assignment_action_id
529: AND ppa.payroll_action_id = assact.payroll_action_id
530: AND paa.assignment_id = assact.assignment_id