APPS.PAY_SLA_UPDATE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

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

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

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

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

Line 605: pay_assignment_actions paa

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

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

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

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

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

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

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

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

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

Line 1087: pay_assignment_actions pa1, -- Cost asg actions

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