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_JP_UITE_ARCH_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 685: PROCEDURE proc_insert_row( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

681: RETURN lt_res_tb;
682: END get_insert_action_info;
683: --
684:
685: PROCEDURE proc_insert_row( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
686: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
687: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
688: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
689: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE

Line 877: PROCEDURE proc_sal_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

873: RAISE gc_exception;
874: --
875: END proc_insert_row;
876: --
877: PROCEDURE proc_sal_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
878: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
879: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
880: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE

Line 924: FROM pay_assignment_actions PAA

920: PTP.end_date,
921: PAF.payroll_id,
922: PAF.effective_start_date,
923: PAF.effective_end_date
924: FROM pay_assignment_actions PAA
925: ,pay_payroll_actions PPA
926: ,per_time_periods PTP
927: ,per_assignments_f PAF
928: WHERE PAA.assignment_id = p_assignment_id

Line 940: pay_assignment_actions PAAI,

936: AND PPA.action_type in ('R','Q','G','L')
937: AND NOT EXISTS(
938: SELECT null
939: FROM pay_action_interlocks PAI,
940: pay_assignment_actions PAAI,
941: pay_payroll_actions PPAI
942: WHERE PAI.locked_action_id = PAA.assignment_action_id
943: AND PAAI.assignment_action_id = PAI.locking_action_id
944: AND PPAI.payroll_action_id = PAAI.payroll_action_id

Line 961: FROM pay_assignment_actions PAA

957: PTP.end_date,
958: PAF.payroll_id,
959: PAF.effective_start_date,
960: PAF.effective_end_date
961: FROM pay_assignment_actions PAA
962: ,pay_payroll_actions PPA
963: ,per_time_periods PTP
964: ,per_assignments_f PAF
965: WHERE PAA.assignment_id = p_assignment_id

Line 977: pay_assignment_actions PAAI,

973: AND PPA.action_type in ('R','Q','G','L')
974: AND NOT EXISTS(
975: SELECT null
976: FROM pay_action_interlocks PAI,
977: pay_assignment_actions PAAI,
978: pay_payroll_actions PPAI
979: WHERE PAI.locked_action_id = PAA.assignment_action_id
980: AND PAAI.assignment_action_id = PAI.locking_action_id
981: AND PPAI.payroll_action_id = PAAI.payroll_action_id

Line 1012: CURSOR lcu_balance_asg_run(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE

1008: AND PBD.database_item_suffix = p_database_item_suffix
1009: AND PBT.balance_type_id = PDB.balance_type_id
1010: AND PBD.balance_dimension_id = PDB.balance_dimension_id;
1011: --
1012: CURSOR lcu_balance_asg_run(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
1013: ,p_balance_type_id pay_balance_types.balance_type_id%TYPE)
1014: IS
1015: SELECT 'Y'
1016: FROM pay_assignment_actions ASSACT,

Line 1016: FROM pay_assignment_actions ASSACT,

1012: CURSOR lcu_balance_asg_run(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
1013: ,p_balance_type_id pay_balance_types.balance_type_id%TYPE)
1014: IS
1015: SELECT 'Y'
1016: FROM pay_assignment_actions ASSACT,
1017: pay_payroll_actions PACT,
1018: pay_balance_feeds_f FEED,
1019: pay_run_results RR,
1020: pay_run_result_values TARGET

Line 1036: FROM pay_assignment_actions ASSACT,

1032: ,p_date_earned pay_payroll_actions.date_earned%TYPE
1033: )
1034: IS
1035: SELECT ASSACT.assignment_action_id
1036: FROM pay_assignment_actions ASSACT,
1037: pay_payroll_actions PACT,
1038: pay_balance_feeds_f FEED,
1039: pay_run_results RR,
1040: pay_run_result_values TARGET

Line 1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1092: ln_sal_a_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days
1095: ln_line_count NUMBER;
1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1097: ln_prev_ass_a_act_id pay_assignment_actions.assignment_action_id%TYPE;
1098: ln_prev_ass_b_act_id pay_assignment_actions.assignment_action_id%TYPE;
1099: --
1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1097: ln_prev_ass_a_act_id pay_assignment_actions.assignment_action_id%TYPE;

1093: ln_sal_b_prev_baltyp_id pay_balance_types.balance_type_id%TYPE;
1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days
1095: ln_line_count NUMBER;
1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1097: ln_prev_ass_a_act_id pay_assignment_actions.assignment_action_id%TYPE;
1098: ln_prev_ass_b_act_id pay_assignment_actions.assignment_action_id%TYPE;
1099: --
1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: ld_effective_date pay_payroll_actions.effective_date%TYPE;

Line 1098: ln_prev_ass_b_act_id pay_assignment_actions.assignment_action_id%TYPE;

1094: ln_wage_dis_count NUMBER:=0; -- Count excluding payment days less than 11 Days
1095: ln_line_count NUMBER;
1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1097: ln_prev_ass_a_act_id pay_assignment_actions.assignment_action_id%TYPE;
1098: ln_prev_ass_b_act_id pay_assignment_actions.assignment_action_id%TYPE;
1099: --
1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1102: ld_date_earned pay_payroll_actions.date_earned%TYPE;

Line 1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;

1096: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1097: ln_prev_ass_a_act_id pay_assignment_actions.assignment_action_id%TYPE;
1098: ln_prev_ass_b_act_id pay_assignment_actions.assignment_action_id%TYPE;
1099: --
1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1102: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1103: ld_period_start_date per_time_periods.start_date%TYPE;
1104: ld_period_end_date per_time_periods.end_date%TYPE;

Line 1734: PROCEDURE proc_spb_arch(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1730: --
1731: END proc_sal_arch;
1732: --
1733:
1734: PROCEDURE proc_spb_arch(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1735: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1736: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1737: ,p_period_start_date IN per_time_periods.start_date%TYPE
1738: ,p_period_end_date IN per_time_periods.end_date%TYPE

Line 1779: FROM pay_assignment_actions paa,

1775: IS
1776: SELECT paa.assignment_action_id,
1777: ppa.effective_date,
1778: ppa.date_earned
1779: FROM pay_assignment_actions paa,
1780: pay_payroll_actions ppa
1781: WHERE paa.assignment_id = p_assignment_id
1782: AND paa.action_status = 'C'
1783: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1791: pay_assignment_actions paa2,

1787: AND ppa.action_type in ('R','Q','G','L')
1788: AND NOT EXISTS(
1789: SELECT null
1790: FROM pay_action_interlocks pai,
1791: pay_assignment_actions paa2,
1792: pay_payroll_actions ppa2
1793: WHERE pai.locked_action_id = paa.assignment_action_id
1794: AND paa2.assignment_action_id = pai.locking_action_id
1795: AND ppa2.payroll_action_id = paa2.payroll_action_id

Line 1887: PROCEDURE proc_term_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE

1883:
1884: --
1885: END proc_spb_arch;
1886: --
1887: PROCEDURE proc_term_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1888: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
1889: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1890: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1891: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE

Line 2463: SELECT pay_assignment_actions_s.NEXTVAL

2459: ORDER BY PAF.assignment_id;
2460: --
2461: CURSOR lcu_next_action_id
2462: IS
2463: SELECT pay_assignment_actions_s.NEXTVAL
2464: FROM dual;
2465: --
2466: -- Local Variables
2467: lt_org_id per_jp_report_common_pkg.gt_org_tbl;

Line 2623: PROCEDURE ARCHIVE_CODE ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type

2619: RAISE gc_exception;
2620: END assignment_action_code;
2621: --
2622: --
2623: PROCEDURE ARCHIVE_CODE ( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
2624: , p_effective_date IN pay_payroll_actions.effective_date%type
2625: )
2626: --************************************************************************
2627: -- PROCEDURE

Line 2652: CURSOR lcu_get_assignment_id ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type )

2648: -- None
2649: --************************************************************************
2650: IS
2651: --
2652: CURSOR lcu_get_assignment_id ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type )
2653: IS
2654: SELECT assignment_id
2655: FROM pay_assignment_actions
2656: WHERE assignment_action_id = p_assignment_action_id;

Line 2655: FROM pay_assignment_actions

2651: --
2652: CURSOR lcu_get_assignment_id ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type )
2653: IS
2654: SELECT assignment_id
2655: FROM pay_assignment_actions
2656: WHERE assignment_action_id = p_assignment_action_id;
2657: --
2658: CURSOR lcu_employee_details ( p_assignment_id NUMBER
2659: , p_effective_date DATE