APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 615: return pay_assignment_actions.assignment_action_id%type is

611: ---------------------------------------------------------------------------
612: function get_latest_asg_act_ext (p_assignment_id in number,
613: p_ext_end_date in date,
614: p_ben_start_date in date)
615: return pay_assignment_actions.assignment_action_id%type is
616:
617: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
618:
619: cursor csr_latest_asg_act_id is

Line 617: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

613: p_ext_end_date in date,
614: p_ben_start_date in date)
615: return pay_assignment_actions.assignment_action_id%type is
616:
617: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
618:
619: cursor csr_latest_asg_act_id is
620: select max(paa.assignment_action_id)
621: from per_time_periods ptp,

Line 623: pay_assignment_actions paa

619: cursor csr_latest_asg_act_id is
620: select max(paa.assignment_action_id)
621: from per_time_periods ptp,
622: pay_payroll_actions pact,
623: pay_assignment_actions paa
624: where paa.assignment_id = p_assignment_id
625: and paa.payroll_action_id = pact.payroll_action_id
626: and pact.time_period_id = ptp.time_period_id
627: and pact.action_type in ('Q','R','B','I','V')

Line 664: return pay_assignment_actions.assignment_action_id%type is

660: ---------------------------------------------------------------------------
661: function get_latest_asg_act_tye (p_assignment_id in number,
662: p_tax_year_end_date in date,
663: p_ben_start_date in date)
664: return pay_assignment_actions.assignment_action_id%type is
665:
666: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
667:
668: cursor csr_latest_asg_act_id is

Line 666: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

662: p_tax_year_end_date in date,
663: p_ben_start_date in date)
664: return pay_assignment_actions.assignment_action_id%type is
665:
666: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
667:
668: cursor csr_latest_asg_act_id is
669: select max(paa.assignment_action_id)
670: from per_time_periods ptp,

Line 672: pay_assignment_actions paa

668: cursor csr_latest_asg_act_id is
669: select max(paa.assignment_action_id)
670: from per_time_periods ptp,
671: pay_payroll_actions pact,
672: pay_assignment_actions paa
673: where paa.assignment_id = p_assignment_id
674: and paa.payroll_action_id = pact.payroll_action_id
675: and pact.time_period_id = ptp.time_period_id
676: and pact.action_type in ('Q','R','B','I','V')

Line 928: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;

924: -- Description: Function returns mileage balance for a specific assignment
925: ---------------------------------------------------------------------------
926: function mileage_balance (p_assignment_id in number) return varchar2 is
927:
928: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
929: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
930:
931: l_bus_group_id number;
932:

Line 929: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;

925: ---------------------------------------------------------------------------
926: function mileage_balance (p_assignment_id in number) return varchar2 is
927:
928: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
929: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
930:
931: l_bus_group_id number;
932:
933: l_ext_end_date date;

Line 1080: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;

1076: -- assignment
1077: ---------------------------------------------------------------------------
1078: function add_pass_balance (p_assignment_id in number) return varchar2 is
1079:
1080: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
1081: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
1082:
1083: l_bus_group_id number;
1084:

Line 1081: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;

1077: ---------------------------------------------------------------------------
1078: function add_pass_balance (p_assignment_id in number) return varchar2 is
1079:
1080: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
1081: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
1082:
1083: l_bus_group_id number;
1084:
1085: l_ext_end_date date;

Line 1278: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;

1274:
1275: l_odd_even_marker varchar2(5);
1276: l_ext_end_date date;
1277: l_ben_start_date date;
1278: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
1279: l_miles number;
1280: l_miles_temp number;
1281: l_include varchar2(10);
1282: l_tax_year_end date;

Line 2009: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;

2005: ,p_taxable_passenger_payments out nocopy varchar2
2006: )
2007: return varchar2 is
2008:
2009: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
2010: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
2011:
2012: l_bus_group_id number;
2013:

Line 2010: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;

2006: )
2007: return varchar2 is
2008:
2009: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
2010: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
2011:
2012: l_bus_group_id number;
2013:
2014: l_ext_end_date date;