APPS.PAY_PL_UTILITY dependencies on PAY_PL_PAYE_DETAILS_F

Line 435: from pay_pl_paye_details_f pppdf,

431:
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

Line 456: /* The 3 variables needed to fetch tax params from pay_pl_paye_details_f*/

452: l_payroll_end_date date;
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:

Line 459: l_paye_contract_category pay_pl_paye_details_f.contract_category%type;

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);
462:
463: begin

Line 520: --pick up_values from pay_pl_paye_details_f with person_id and date as of ptp.end_date

516:
517: --No payroll has been run for any Normal Contract of this person in the current payroll period
518: if l_per_system_status<>'TERM_ASSIGN' then
519: --Active Normal Contract,
520: --pick up_values from pay_pl_paye_details_f with person_id and date as of ptp.end_date
521:
522: l_join_variable :=l_person_id;
523: l_paye_contract_category:='NORMAL';
524: l_paye_table_date:=l_payroll_end_date;