eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 578: return pay_assignment_actions.assignment_action_id%type is

574: ---------------------------------------------------------------------------
575: function get_latest_asg_act_ext (p_assignment_id in number,
576: p_ext_end_date in date,
577: p_ben_start_date in date)
578: return pay_assignment_actions.assignment_action_id%type is
579:
580: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
581:
582: cursor csr_latest_asg_act_id is

Line 580: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

576: p_ext_end_date in date,
577: p_ben_start_date in date)
578: return pay_assignment_actions.assignment_action_id%type is
579:
580: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
581:
582: cursor csr_latest_asg_act_id is
583: select max(paa.assignment_action_id)
584: from per_time_periods ptp,

Line 586: pay_assignment_actions paa

582: cursor csr_latest_asg_act_id is
583: select max(paa.assignment_action_id)
584: from per_time_periods ptp,
585: pay_payroll_actions pact,
586: pay_assignment_actions paa
587: where paa.assignment_id = p_assignment_id
588: and paa.payroll_action_id = pact.payroll_action_id
589: and pact.time_period_id = ptp.time_period_id
590: and pact.action_type in ('Q','R','B','I','V')

Line 626: return pay_assignment_actions.assignment_action_id%type is

622: ---------------------------------------------------------------------------
623: function get_latest_asg_act_tye (p_assignment_id in number,
624: p_tax_year_end_date in date,
625: p_ben_start_date in date)
626: return pay_assignment_actions.assignment_action_id%type is
627:
628: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
629:
630: cursor csr_latest_asg_act_id is

Line 628: l_asg_act_id pay_assignment_actions.assignment_action_id%type;

624: p_tax_year_end_date in date,
625: p_ben_start_date in date)
626: return pay_assignment_actions.assignment_action_id%type is
627:
628: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
629:
630: cursor csr_latest_asg_act_id is
631: select max(paa.assignment_action_id)
632: from per_time_periods ptp,

Line 634: pay_assignment_actions paa

630: cursor csr_latest_asg_act_id is
631: select max(paa.assignment_action_id)
632: from per_time_periods ptp,
633: pay_payroll_actions pact,
634: pay_assignment_actions paa
635: where paa.assignment_id = p_assignment_id
636: and paa.payroll_action_id = pact.payroll_action_id
637: and pact.time_period_id = ptp.time_period_id
638: and pact.action_type in ('Q','R','B','I','V')

Line 889: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;

885: -- Description: Function returns mileage balance for a specific assignment
886: ---------------------------------------------------------------------------
887: function mileage_balance (p_assignment_id in number) return varchar2 is
888:
889: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
890: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
891:
892: l_bus_group_id number;
893:

Line 890: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;

886: ---------------------------------------------------------------------------
887: function mileage_balance (p_assignment_id in number) return varchar2 is
888:
889: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
890: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
891:
892: l_bus_group_id number;
893:
894: l_ext_end_date date;

Line 1041: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;

1037: -- assignment
1038: ---------------------------------------------------------------------------
1039: function add_pass_balance (p_assignment_id in number) return varchar2 is
1040:
1041: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
1042: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
1043:
1044: l_bus_group_id number;
1045:

Line 1042: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;

1038: ---------------------------------------------------------------------------
1039: function add_pass_balance (p_assignment_id in number) return varchar2 is
1040:
1041: l_asg_act_id_tye pay_assignment_actions.assignment_action_id%type;
1042: l_asg_act_id_ext pay_assignment_actions.assignment_action_id%type;
1043:
1044: l_bus_group_id number;
1045:
1046: l_ext_end_date date;