APPS.PAY_PL_UTILITY dependencies on PAY_PL_SII_DETAILS_F

Line 91: from pay_pl_sii_details_f

87: labor_contribution,
88: unemployment_contribution,
89: health_contribution
90:
91: from pay_pl_sii_details_f
92: where per_or_asg_id=r_per_or_asg_id
93: and contract_category=r_contract_category
94: and r_sii_date between effective_start_date and effective_end_date ;
95:

Line 98: l_join_variable pay_pl_sii_details_f.per_or_asg_id%type;

94: and r_sii_date between effective_start_date and effective_end_date ;
95:
96: l_contract_category hr_soft_coding_keyflex.segment3%type;
97: l_per_system_status per_assignment_status_types.per_system_status%type;
98: l_join_variable pay_pl_sii_details_f.per_or_asg_id%type;
99: l_date_earned date;
100: l_date_terminated date;
101: l_payroll_id number;
102: l_sii_date date;

Line 436: pay_pl_sii_details_f ppsdf

432: cursor csr_get_tax_details(r_per_or_asg_id number,r_contract_category varchar2,r_date date ) is
433: select TAX_REDUCTION,TAX_CALC_WITH_SPOUSE_CHILD,INCOME_REDUCTION,
434: INCOME_REDUCTION_AMOUNT,RATE_OF_TAX,EMP_SOCIAL_SECURITY_INFO
435: from pay_pl_paye_details_f pppdf,
436: pay_pl_sii_details_f ppsdf
437: where pppdf.per_or_asg_id =r_per_or_asg_id
438: and r_date between pppdf.effective_start_date and pppdf.effective_end_date
439: and pppdf.contract_category=r_contract_category
440: and ppsdf.per_or_asg_id =r_per_or_asg_id

Line 457: l_join_variable pay_pl_sii_details_f.per_or_asg_id%type;

453: l_payroll_run varchar2(1);--'Y' or 'N'
454: l_assignment_action_id number;
455:
456: /* The 3 variables needed to fetch tax params from pay_pl_paye_details_f*/
457: l_join_variable pay_pl_sii_details_f.per_or_asg_id%type;
458: l_paye_table_date date;
459: l_paye_contract_category pay_pl_paye_details_f.contract_category%type;
460:
461: l_proc_name varchar2(33);