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_NO_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 83: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

79: ,p_token IN VARCHAR2
80: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
81: IS
82:
83: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
84: l_start_pos NUMBER;
85: l_delimiter VARCHAR2(1):=' ';
86: l_proc VARCHAR2(40):= g_package||' get parameter ';
87:

Line 142: FROM pay_payroll_actions

138: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
139: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
140: ,effective_date
141: ,business_group_id
142: FROM pay_payroll_actions
143: WHERE payroll_action_id = p_payroll_action_id;
144:
145: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
146: --

Line 226: ,pay_payroll_actions ppa

222: ptp.start_date start_date,
223: ptp.period_name period_name,
224: ppf.payroll_name payroll_name
225: FROM per_time_periods ptp
226: ,pay_payroll_actions ppa
227: ,pay_payrolls_f ppf
228: WHERE ptp.payroll_id = ppa.payroll_id
229: AND ppa.payroll_action_id = p_run_payact_id
230: AND ppa.payroll_id = ppf.payroll_id

Line 825: ,pay_payroll_actions ppa

821: CLOSE csr_get_element;
822:
823: p_sql := 'SELECT DISTINCT person_id
824: FROM per_people_f ppf
825: ,pay_payroll_actions ppa
826: WHERE ppa.payroll_action_id = :payroll_action_id
827: AND ppa.business_group_id = ppf.business_group_id
828: ORDER BY ppf.person_id';
829:

Line 866: FROM pay_payroll_actions ppa,

862: IS
863: SELECT act.assignment_id assignment_id,
864: act.assignment_action_id run_action_id,
865: act1.assignment_action_id prepaid_action_id
866: FROM pay_payroll_actions ppa,
867: pay_payroll_actions appa,
868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,

Line 867: pay_payroll_actions appa,

863: SELECT act.assignment_id assignment_id,
864: act.assignment_action_id run_action_id,
865: act1.assignment_action_id prepaid_action_id
866: FROM pay_payroll_actions ppa,
867: pay_payroll_actions appa,
868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,
871: pay_action_interlocks pai,

Line 868: pay_payroll_actions appa2,

864: act.assignment_action_id run_action_id,
865: act1.assignment_action_id prepaid_action_id
866: FROM pay_payroll_actions ppa,
867: pay_payroll_actions appa,
868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,
871: pay_action_interlocks pai,
872: per_all_assignments_f as1

Line 894: pay_payroll_actions appa3

890:
891: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
892: FROM pay_action_interlocks pai1,
893: pay_assignment_actions act2,
894: pay_payroll_actions appa3
895: WHERE pai1.locked_action_id = act.assignment_action_id
896: AND act2.assignment_action_id= pai1.locking_action_id
897: AND act2.payroll_action_id = appa3.payroll_action_id
898: AND appa3.action_type = 'X'

Line 905: pay_payroll_actions appa3

901:
902: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
903: FROM pay_action_interlocks pai1,
904: pay_assignment_actions act2,
905: pay_payroll_actions appa3
906: WHERE pai1.locked_action_id = act.assignment_action_id
907: AND act2.assignment_action_id= pai1.locking_action_id
908: AND act2.payroll_action_id = appa3.payroll_action_id
909: AND appa3.action_type = 'V'

Line 1012: ,pay_payroll_actions prepay_payact

1008: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
1009: ,run_payact.date_earned date_earned
1010: FROM pay_action_interlocks archive_intlck
1011: ,pay_assignment_actions prepay_assact
1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact
1015: ,pay_payroll_actions run_payact
1016: ,pay_assignment_actions archive_assact

Line 1015: ,pay_payroll_actions run_payact

1011: ,pay_assignment_actions prepay_assact
1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact
1015: ,pay_payroll_actions run_payact
1016: ,pay_assignment_actions archive_assact
1017: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
1018: and archive_assact.payroll_action_id = p_payroll_action_id
1019: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 1037: ,pay_payroll_actions prepay_payact

1033: ,run_payact.date_earned date_earned
1034: ,run_payact.payroll_action_id run_payact_id
1035: FROM pay_action_interlocks archive_intlck
1036: ,pay_assignment_actions prepay_assact
1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact
1040: ,pay_payroll_actions run_payact
1041: ,pay_assignment_actions archive_assact

Line 1040: ,pay_payroll_actions run_payact

1036: ,pay_assignment_actions prepay_assact
1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact
1040: ,pay_payroll_actions run_payact
1041: ,pay_assignment_actions archive_assact
1042: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
1043: and archive_assact.payroll_action_id = p_payroll_action_id
1044: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 2827: ,pay_payroll_actions ppa

2823: ,pay_element_types_f pet
2824: ,pay_element_links_f pel
2825: ,pay_element_entries_f pee
2826: ,pay_assignment_actions paa
2827: ,pay_payroll_actions ppa
2828: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
2829: AND pel.element_type_id = pet.element_type_id
2830: AND pee.element_link_id = pel.element_link_id
2831: AND paa.assignment_id = pee.assignment_id

Line 3074: ,pay_payroll_actions ppa

3070: ,rr.element_entry_id ele_entry_id
3071: FROM pay_run_result_values rrv
3072: ,pay_run_results rr
3073: ,pay_assignment_actions paa
3074: ,pay_payroll_actions ppa
3075: WHERE rrv.input_value_id = p_iv_id
3076: AND rr.element_type_id = p_ele_type_id
3077: AND rr.run_result_id = rrv.run_result_id
3078: AND rr.assignment_action_id = paa.assignment_action_id

Line 3567: ,pay_payroll_actions prepay_payact

3563: ,run_payact.payroll_action_id run_payact_id
3564: ,run_payact.payroll_id payroll_id
3565: FROM pay_action_interlocks archive_intlck
3566: ,pay_assignment_actions prepay_assact
3567: ,pay_payroll_actions prepay_payact
3568: ,pay_action_interlocks prepay_intlck
3569: ,pay_assignment_actions run_assact
3570: ,pay_payroll_actions run_payact
3571: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 3570: ,pay_payroll_actions run_payact

3566: ,pay_assignment_actions prepay_assact
3567: ,pay_payroll_actions prepay_payact
3568: ,pay_action_interlocks prepay_intlck
3569: ,pay_assignment_actions run_assact
3570: ,pay_payroll_actions run_payact
3571: WHERE archive_intlck.locking_action_id = p_locking_action_id
3572: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
3573: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
3574: AND prepay_payact.action_type IN ('U','P')

Line 3594: ,pay_payroll_actions prepay_payact

3590: ,run_payact.payroll_action_id run_payact_id
3591: ,run_payact.payroll_id payroll_id
3592: FROM pay_action_interlocks archive_intlck
3593: ,pay_assignment_actions prepay_assact
3594: ,pay_payroll_actions prepay_payact
3595: ,pay_action_interlocks prepay_intlck
3596: ,pay_assignment_actions run_assact
3597: ,pay_payroll_actions run_payact
3598: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 3597: ,pay_payroll_actions run_payact

3593: ,pay_assignment_actions prepay_assact
3594: ,pay_payroll_actions prepay_payact
3595: ,pay_action_interlocks prepay_intlck
3596: ,pay_assignment_actions run_assact
3597: ,pay_payroll_actions run_payact
3598: WHERE archive_intlck.locking_action_id = p_locking_action_id
3599: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
3600: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
3601: AND prepay_payact.action_type IN ('U','P')

Line 3621: ,pay_payroll_actions ppa

3617: ppa.date_earned date_earned,
3618: ppa.effective_date effective_date,
3619: ptp.start_date start_date
3620: FROM per_time_periods ptp
3621: ,pay_payroll_actions ppa
3622: ,pay_assignment_actions paa
3623: WHERE ptp.payroll_id =ppa.payroll_id
3624: AND ppa.payroll_action_id =paa.payroll_action_id
3625: AND paa.assignment_action_id =p_assact_id

Line 3642: l_date_earned pay_payroll_actions.date_earned%TYPE;

3638: l_end_date per_time_periods.end_date%TYPE;
3639: l_pre_end_date per_time_periods.end_date%TYPE;
3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3644: l_effective_date pay_payroll_actions.effective_date%TYPE;
3645: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
3646: l_run_payact_id NUMBER;

Line 3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

3639: l_pre_end_date per_time_periods.end_date%TYPE;
3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3644: l_effective_date pay_payroll_actions.effective_date%TYPE;
3645: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
3646: l_run_payact_id NUMBER;
3647: l_action_context_id NUMBER;

Line 3644: l_effective_date pay_payroll_actions.effective_date%TYPE;

3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3644: l_effective_date pay_payroll_actions.effective_date%TYPE;
3645: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
3646: l_run_payact_id NUMBER;
3647: l_action_context_id NUMBER;
3648: g_archive_pact NUMBER;

Line 3645: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3644: l_effective_date pay_payroll_actions.effective_date%TYPE;
3645: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
3646: l_run_payact_id NUMBER;
3647: l_action_context_id NUMBER;
3648: g_archive_pact NUMBER;
3649: p_assactid NUMBER;

Line 3715: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.

3711: ,p_effective_date => p_effective_date);
3712: */
3713:
3714: -- using l_date_earned (Payroll Run Date Earned) instead of l_pre_date_earned (Prepayments Date Earned)
3715: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.
3716:
3717: ARCHIVE_EMPLOYEE_DETAILS(p_archive_assact_id => p_assignment_action_id
3718: ,p_assignment_id => rec_archive_ids.run_assgt_id
3719: ,p_assignment_action_id => rec_archive_ids.run_assact_id

Line 3753: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.

3749: p_effective_date => p_effective_date);
3750: */
3751:
3752: -- using l_date_earned (Payroll Run Date Earned) instead of l_pre_date_earned (Prepayments Date Earned)
3753: -- because the date_earned column at table pay_payroll_actions for Prepayments may not always be populated.
3754:
3755: ARCHIVE_PAYMENT_INFO(p_archive_assact_id => p_assignment_action_id,
3756: p_prepay_assact_id => rec_archive_ids.prepay_assact_id,
3757: p_assignment_id => rec_archive_ids.prepay_assgt_id,

Line 3929: FROM pay_payroll_actions

3925: -------------
3926: /* cursor to get the payroll_d */
3927: CURSOR csr_payroll (p_payroll_action_id NUMBER) IS
3928: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
3929: FROM pay_payroll_actions
3930: WHERE payroll_action_id = p_payroll_action_id ;
3931:
3932:
3933: /* cursor to get the payroll details */

Line 4348: ,pay_payroll_actions ppa

4344: ,rr.element_entry_id ele_entry_id
4345: FROM pay_run_result_values rrv
4346: ,pay_run_results rr
4347: ,pay_assignment_actions paa
4348: ,pay_payroll_actions ppa
4349: WHERE rrv.input_value_id = p_iv_id
4350: AND rr.element_type_id = p_ele_type_id
4351: AND rr.run_result_id = rrv.run_result_id
4352: AND rr.assignment_action_id = paa.assignment_action_id

Line 4431: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa

4427:
4428: -- cursor to get the reduced tax rule for the period
4429: CURSOR csr_get_reduced_tax_rule (p_asg_act_id number) IS
4430: SELECT ptp.prd_information1
4431: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa
4432: WHERE paa.ASSIGNMENT_ACTION_ID = p_asg_act_id
4433: AND ppa.payroll_action_id = paa.PAYROLL_ACTION_ID
4434: AND ppa.time_period_id = ptp.time_period_id ;
4435: