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_PAYROLL_ACTIONS

Line 66: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

62: gc_date_earned CONSTANT VARCHAR2(30) := 'DATE_EARNED';
63: gc_date_paid CONSTANT VARCHAR2(30) := 'DATE_PAID';
64: gn_max_period CONSTANT NUMBER := 48;
65: -- Declaration of global variables
66: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
67: gn_business_group_id hr_all_organization_units.organization_id%TYPE;
68: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
69: gb_debug BOOLEAN;
70: gd_end_date DATE;

Line 68: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

64: gn_max_period CONSTANT NUMBER := 48;
65: -- Declaration of global variables
66: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
67: gn_business_group_id hr_all_organization_units.organization_id%TYPE;
68: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
69: gb_debug BOOLEAN;
70: gd_end_date DATE;
71: gd_start_date DATE;
72: gc_exception EXCEPTION;

Line 686: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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
690: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE

Line 688: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
690: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
691: ,p_hire_date IN per_periods_of_service.date_start%TYPE
692: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE

Line 735: ld_effective_date pay_payroll_actions.effective_date%TYPE;

731: AND p_termination_date BETWEEN PTP.start_date AND PTP.end_date
732: ORDER BY PTP.start_date DESC;
733: --
734: ln_diff_mth NUMBER;
735: ld_effective_date pay_payroll_actions.effective_date%TYPE;
736: ld_date_earned pay_payroll_actions.date_earned%TYPE;
737: ld_period_start_date per_time_periods.start_date%TYPE;
738: ld_period_end_date per_time_periods.end_date%TYPE;
739: ld_insured_start_date per_time_periods.start_date%TYPE;

Line 736: ld_date_earned pay_payroll_actions.date_earned%TYPE;

732: ORDER BY PTP.start_date DESC;
733: --
734: ln_diff_mth NUMBER;
735: ld_effective_date pay_payroll_actions.effective_date%TYPE;
736: ld_date_earned pay_payroll_actions.date_earned%TYPE;
737: ld_period_start_date per_time_periods.start_date%TYPE;
738: ld_period_end_date per_time_periods.end_date%TYPE;
739: ld_insured_start_date per_time_periods.start_date%TYPE;
740: ld_insured_end_date per_time_periods.end_date%TYPE;

Line 878: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE

Line 880: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
883: ,p_hire_date IN per_periods_of_service.date_start%TYPE
884: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE

Line 925: ,pay_payroll_actions PPA

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
929: AND PAF.assignment_id = PAA.assignment_id

Line 941: pay_payroll_actions PPAI

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
945: AND PPAI.action_type = 'V')

Line 962: ,pay_payroll_actions PPA

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
966: AND PAF.assignment_id = PAA.assignment_id

Line 978: pay_payroll_actions PPAI

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
982: AND PPAI.action_type = 'V')

Line 1017: pay_payroll_actions PACT,

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
1021: WHERE ASSACT.assignment_action_id = p_assignment_action_id

Line 1032: ,p_date_earned pay_payroll_actions.date_earned%TYPE

1028: AND FEED.balance_type_id = p_balance_type_id
1029: AND PACT.effective_date BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
1030: --
1031: CURSOR lcu_balance_asg_prev_run(p_balance_type_id pay_balance_types.balance_type_id%TYPE
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,

Line 1037: pay_payroll_actions PACT,

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
1041: WHERE PACT.payroll_action_id = ASSACT.payroll_action_id

Line 1101: ld_effective_date pay_payroll_actions.effective_date%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;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;

Line 1102: ld_date_earned pay_payroll_actions.date_earned%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;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;
1106: ld_insured_end_date per_time_periods.end_date%TYPE;

Line 1736: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
1739: ,p_payroll_id IN NUMBER)
1740: --***************************************************************************

Line 1780: pay_payroll_actions ppa

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
1784: AND ppa.effective_date

Line 1792: pay_payroll_actions ppa2

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
1796: AND ppa2.action_type = 'V')

Line 1888: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

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
1892: )

Line 1890: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE

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
1892: )
1893: --***************************************************************************
1894: -- PROCEDURE

Line 2026: PROCEDURE RANGE_CODE ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE

2022: RAISE gc_exception;
2023: --
2024: END proc_term_arch;
2025: --
2026: PROCEDURE RANGE_CODE ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
2027: ,p_sql OUT NOCOPY VARCHAR2
2028: )
2029: --***************************************************************************
2030: -- PROCEDURE

Line 2070: ' pay_payroll_actions pa' ||

2066: -- sql string to SELECT a range of assignments eligible for archival.
2067: -------------------------------------------------------------------------
2068: p_sql := ' SELECT distinct p.person_id' ||
2069: ' FROM per_people_f p,' ||
2070: ' pay_payroll_actions pa' ||
2071: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
2072: ' AND p.business_group_id = pa.business_group_id' ||
2073: ' ORDER BY p.person_id';
2074: --

Line 2085: PROCEDURE initialize ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )

2081: END IF;
2082: --
2083: END RANGE_CODE;
2084: --
2085: PROCEDURE initialize ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )
2086: --*************************************************************************
2087: -- PROCEDURE
2088: -- initialize
2089: --

Line 2110: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

2106: -- INITIALIZATION_CODE
2107: --*************************************************************************
2108: IS
2109: --
2110: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2111: --*************************************************************************
2112: --
2113: -- CURSOR lcr_params
2114: --

Line 2138: FROM pay_payroll_actions PPA

2134: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD')
2135: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD')
2136: ,pay_core_utils.get_parameter('LIO',legislative_parameters)
2137: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD')
2138: FROM pay_payroll_actions PPA
2139: WHERE PPA.payroll_action_id = p_payroll_action_id;
2140:
2141: --
2142: --*************************************************************************

Line 2236: PROCEDURE INITIALIZATION_CODE ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE )

2232: hr_utility.set_location('Error in '||lc_procedure,999999);
2233: RAISE;
2234: END initialize;
2235: --
2236: PROCEDURE INITIALIZATION_CODE ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE )
2237: --***************************************************************************
2238: -- PROCEDURE
2239: -- INITIALIZATION_CODE
2240: --

Line 2357: PROCEDURE assignment_action_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type

2353: lb_return := FALSE;
2354: RETURN lb_return;
2355: END range_person_on;
2356: --
2357: PROCEDURE assignment_action_code ( p_payroll_action_id IN pay_payroll_actions.payroll_action_id%type
2358: ,p_start_person IN per_all_people_f.person_id%type
2359: ,p_end_person IN per_all_people_f.person_id%type
2360: ,p_chunk IN NUMBER
2361: )

Line 2410: ,pay_payroll_actions PPA

2406: FROM per_people_f PPF
2407: ,per_assignments_f PAF
2408: ,per_periods_of_service PPS
2409: ,pay_population_ranges PPR
2410: ,pay_payroll_actions PPA
2411: WHERE PPF.person_id = PAF.person_id
2412: AND PPF.person_id = PPS.person_id
2413: AND PPA.payroll_action_id = p_payroll_action_id
2414: AND PPA.payroll_action_id = PPR.payroll_action_id

Line 2624: , p_effective_date IN pay_payroll_actions.effective_date%type

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
2628: -- ARCHIVE_CODE