APPS.PAY_SLA_UPDATE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 598: FUNCTION get_full_name(p_assignment_act_id in pay_assignment_actions.assignment_action_id%type,

594: -- Name : GET_FULL_NAME
595: -- Function : TO get the Full Name from Assignment_Action_Id
596: ----------------------------------------------------------------------------------------
597:
598: FUNCTION get_full_name(p_assignment_act_id in pay_assignment_actions.assignment_action_id%type,
599: p_eff_date in date)
600: return varchar2 is
601:
602: Cursor csr_full_name(p_assnmnt_act_id in pay_assignment_actions.assignment_action_id%type,

Line 602: Cursor csr_full_name(p_assnmnt_act_id in pay_assignment_actions.assignment_action_id%type,

598: FUNCTION get_full_name(p_assignment_act_id in pay_assignment_actions.assignment_action_id%type,
599: p_eff_date in date)
600: return varchar2 is
601:
602: Cursor csr_full_name(p_assnmnt_act_id in pay_assignment_actions.assignment_action_id%type,
603: p_eff_date in date)
604: is
605: select full_name
606: from per_people_f ppf,

Line 608: pay_assignment_actions paa

604: is
605: select full_name
606: from per_people_f ppf,
607: per_assignments_f paf,
608: pay_assignment_actions paa
609: where paa.assignment_id=paf.assignment_id
610: and paf.person_id=ppf.person_id
611: and paa.assignment_action_id=p_assnmnt_act_id
612: and p_eff_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1023: pay_assignment_actions pa1, -- Cost asg actions.

1019: decode(pcv.debit_or_credit,'Debit',pcv.costed_value,null) entered_dr,
1020: decode(pcv.debit_or_credit,'Credit',pcv.costed_value,null) entered_cr ,
1021: ppa1.action_type
1022: FROM pay_payroll_actions ppa1, -- Cost pay actions
1023: pay_assignment_actions pa1, -- Cost asg actions.
1024: pay_action_interlocks pi3, -- Cost - Run
1025: pay_action_interlocks pi1, -- Cost - Trans GL
1026: pay_all_payrolls_f pp,
1027: pay_action_classifications pac,

Line 1029: pay_assignment_actions pa2, -- Payroll run asg actions.

1025: pay_action_interlocks pi1, -- Cost - Trans GL
1026: pay_all_payrolls_f pp,
1027: pay_action_classifications pac,
1028: pay_payroll_actions ppa2, -- Payroll run actions.
1029: pay_assignment_actions pa2, -- Payroll run asg actions.
1030: pay_action_interlocks pi2, -- Run - Trans GL
1031: pay_assignment_actions pa, -- Trans GL asg actions
1032: pay_payroll_actions ppa, -- Trans GL pay actions
1033: pay_costs_v pcv,

Line 1031: pay_assignment_actions pa, -- Trans GL asg actions

1027: pay_action_classifications pac,
1028: pay_payroll_actions ppa2, -- Payroll run actions.
1029: pay_assignment_actions pa2, -- Payroll run asg actions.
1030: pay_action_interlocks pi2, -- Run - Trans GL
1031: pay_assignment_actions pa, -- Trans GL asg actions
1032: pay_payroll_actions ppa, -- Trans GL pay actions
1033: pay_costs_v pcv,
1034: gl_je_headers gjh,
1035: gl_je_lines gjl

Line 1088: pay_assignment_actions pa, -- Trans GL asg actions

1084: decode(ppc.debit_or_credit,'Debit',to_number(ppc.costed_value),null) entered_dr,
1085: decode(ppc.debit_or_credit,'Credit',to_number(ppc.costed_value),null) entered_cr,
1086: ppa1.action_type
1087: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1088: pay_assignment_actions pa, -- Trans GL asg actions
1089: pay_action_interlocks pi1, -- Cost - Trans GL
1090: pay_assignment_actions pa1, -- Cost asg actions
1091: pay_payroll_actions ppa1, -- Cost pay actions
1092: per_all_assignments_f pera,

Line 1090: pay_assignment_actions pa1, -- Cost asg actions

1086: ppa1.action_type
1087: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1088: pay_assignment_actions pa, -- Trans GL asg actions
1089: pay_action_interlocks pi1, -- Cost - Trans GL
1090: pay_assignment_actions pa1, -- Cost asg actions
1091: pay_payroll_actions ppa1, -- Cost pay actions
1092: per_all_assignments_f pera,
1093: pay_all_payrolls_f pp,
1094: pay_payment_costs_v ppc,