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

Line 12: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

8: --
9: -- Global Variables
10: --
11: -- Bug c_context_name - PRSI Context Balance Design Change
12: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
13: l_context_id ff_contexts.context_id%TYPE;
14: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
15: p_person_id_global per_people_f.person_id%TYPE; -- to store the person_id in a package level variable to be used in c_context_name cursor
16: l_class_count NUMBER (4);

Line 54: TYPE asg_action_ids_tab IS TABLE OF pay_assignment_actions.assignment_action_id%TYPE

50: l_prsi_class_temp prsi_class_tab; -- For making other tables empty
51:
52: -- declaring a pl/sql table for storing the the max assignment action ids against assignments for a person.
53: -- Bug fix4004470
54: TYPE asg_action_ids_tab IS TABLE OF pay_assignment_actions.assignment_action_id%TYPE
55: INDEX BY BINARY_INTEGER;
56:
57: t_context_value type_context_value_tab;
58: t_empty_table type_context_value_tab; -- for emptying the t_context_value pl/sql table

Line 62: t_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

58: t_empty_table type_context_value_tab; -- for emptying the t_context_value pl/sql table
59:
60: -- t_asg_action_id asg_action_ids_tab; --Bug fix 4004470
61: -- t_empty_asg_table asg_action_ids_tab; -- for emptying the t_asg_action_id pl/sql table( Bug fix 4023794)
62: t_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
63:
64:
65: -- Bug 3460687 Temporary tables to hold Class Names
66: t_context_value_balinit type_context_value_tab;

Line 109: l_actid pay_assignment_actions.assignment_action_id%TYPE;

105: ,p_end_date date
106: ,p_bg_id number)
107: RETURN NUMBER AS
108: l_person_id per_people_f.person_id%TYPE;
109: l_actid pay_assignment_actions.assignment_action_id%TYPE;
110:
111: cursor csr_check_multiple_asg IS
112: select paaf.person_id
113: from per_assignments_f paaf, per_assignments_f paaf1

Line 125: pay_assignment_actions paa,

121:
122: cursor csr_get_max_assact is
123: SELECT MAX(paa.assignment_action_id)
124: FROM per_assignments_f paf,
125: pay_assignment_actions paa,
126: pay_payroll_actions ppa,
127: per_time_periods ptp
128: WHERE paf.person_id = l_person_id
129: AND paf.assignment_id = paa.assignment_id

Line 228: l_child_assignemnt_action pay_assignment_actions.assignment_action_id%TYPE;

224: p_ppsn_override VARCHAR2 default NULL --6633719
225: ) is
226:
227:
228: l_child_assignemnt_action pay_assignment_actions.assignment_action_id%TYPE;
229: l_p60_prsi prsi_class_tab;
230:
231: -- cursor to get child action
232: cursor c1 is

Line 233: select assignment_action_id from pay_assignment_actions

229: l_p60_prsi prsi_class_tab;
230:
231: -- cursor to get child action
232: cursor c1 is
233: select assignment_action_id from pay_assignment_actions
234: where source_action_id = p_max_action_id;
235:
236: -- This fetch all prsi classes from run-results where assignment action id
237: -- lies between child of p_max_action_id and p_assignment_action_id(last period max action id)

Line 249: pay_assignment_actions paa,

245: paa.assignment_action_id,
246: trim(rrv1.result_value) result_value
247: FROM per_people_f per,
248: per_assignments_f asg,
249: pay_assignment_actions paa,
250: pay_payroll_actions ppa,
251: per_time_periods ptp,
252: pay_run_results prr,
253: pay_element_types_f pet,

Line 785: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;

781: l_proc_name VARCHAR2 (100) := l_package|| 'assignment_action_code';
782: l_actid NUMBER;
783: l_locked_action NUMBER;
784: l_out_var VARCHAR2 (30);
785: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
786: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
787: l_temp_person_id per_people_f.person_id%TYPE :=0;
788: l_start_date date;
789: l_end_date date;

Line 809: pay_assignment_actions paa,

805: paa.assignment_id,
806: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,
812: per_time_periods ptp,
813: hr_soft_coding_keyflex flex

Line 838: pay_assignment_actions paa1, --Bug fix 4130665

834: --decode added to pick the previous assignments also in case of ReHire having diff overrides.
835: AND asg.effective_end_date = DECODE(OVERRIDE_PPSN(asg.assignment_id),NULL, --6633719
836: (SELECT MAX (paf.effective_end_date)
837: FROM per_assignments_f paf,
838: pay_assignment_actions paa1, --Bug fix 4130665
839: pay_payroll_actions ppa1,
840: per_time_periods ptp1 --Tar 15081088.6
841: ,pay_all_payrolls_f pay
842: ,hr_soft_coding_keyflex flex1

Line 917: FROM pay_assignment_actions paa_p35,

913: )))
914: OR l_assignment_set_id IS NULL)
915: AND NOT EXISTS (
916: SELECT 1
917: FROM pay_assignment_actions paa_p35,
918: pay_payroll_actions ppa_p35,
919: per_assignments_f paaf_p35,
920: pay_all_payrolls_f ppf_p35,
921: hr_soft_coding_keyflex flex_p35,

Line 935: and plock.locked_action_id in (select assignment_action_id from pay_assignment_actions

931: --AND paa_p35.assignment_id = asg.assignment_id
932: AND paa_p35.assignment_id = paaf_p35.assignment_id
933: AND paaf_p35.person_id = asg.person_id
934: and paa_p35.assignment_action_id = plock.locking_action_id
935: and plock.locked_action_id in (select assignment_action_id from pay_assignment_actions
936: where assignment_id=asg.assignment_id)
937: AND paaf_p35.payroll_id = ppf_p35.payroll_id
938: AND ppf_p35.soft_coding_keyflex_id = flex_p35.soft_coding_keyflex_id
939: AND flex_p35.segment4 = l_segment4)

Line 979: pay_assignment_actions paa,

975: FROM pay_run_result_values prrv,
976: pay_run_results prr,
977: pay_input_values_f pivf,
978: pay_element_types_f pet,
979: pay_assignment_actions paa,
980: pay_payroll_actions ppa
981: WHERE ppa.payroll_action_id= paa.payroll_action_id
982: AND ((paa.source_action_id= p_action_id
983: AND prr.assignment_action_id = paa.assignment_action_id )

Line 1001: pay_assignment_actions paa,

997: FROM pay_run_result_values prrv,
998: pay_run_results prr,
999: pay_input_values_f pivf,
1000: pay_element_types_f pet,
1001: pay_assignment_actions paa,
1002: pay_payroll_actions ppa
1003: WHERE ppa.payroll_action_id= paa.payroll_action_id
1004: AND paa.assignment_id = p_asg_id
1005: AND ((paa.source_action_id between p_action_id_min AND p_action_id_max

Line 1169: FROM pay_assignment_actions paa,

1165:
1166: CURSOR csr_action_type (p_assignment_id NUMBER) IS
1167: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1168: , fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min --12382953
1169: FROM pay_assignment_actions paa,
1170: pay_payroll_actions ppa
1171: WHERE ppa.payroll_action_id = paa.payroll_action_id
1172: and paa.assignment_id = p_assignment_id
1173: and ppa.action_type in ('R','Q')

Line 1180: l_flag_action_id pay_assignment_actions.assignment_action_id%TYPE;

1176:
1177:
1178: l_flag_exclusion varchar2(1) := 'N';
1179: l_flag_action_type pay_payroll_actions.action_type%TYPE;
1180: l_flag_action_id pay_assignment_actions.assignment_action_id%TYPE;
1181:
1182: --12382953
1183: l_min_action_id pay_assignment_actions.assignment_action_id%TYPE;
1184: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1183: l_min_action_id pay_assignment_actions.assignment_action_id%TYPE;

1179: l_flag_action_type pay_payroll_actions.action_type%TYPE;
1180: l_flag_action_id pay_assignment_actions.assignment_action_id%TYPE;
1181:
1182: --12382953
1183: l_min_action_id pay_assignment_actions.assignment_action_id%TYPE;
1184: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
1185: --12382953
1186:
1187: BEGIN

Line 1184: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;

1180: l_flag_action_id pay_assignment_actions.assignment_action_id%TYPE;
1181:
1182: --12382953
1183: l_min_action_id pay_assignment_actions.assignment_action_id%TYPE;
1184: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
1185: --12382953
1186:
1187: BEGIN
1188:

Line 1325: SELECT pay_assignment_actions_s.NEXTVAL

1321: hr_utility.set_location('l_tax_amount: '||to_char(l_tax_amount),19);
1322: --12382953
1323: IF l_count <> 0 OR l_levi_amount <> 0
1324: OR l_usc_amount <> 0 OR l_prsi_amount <> 0 OR l_tax_amount <> 0 THEN --8874161 --12382953
1325: SELECT pay_assignment_actions_s.NEXTVAL
1326: INTO l_actid
1327: FROM DUAL;
1328:
1329: hr_utility.set_location('INSIDE IF',18);

Line 1352: SELECT pay_assignment_actions_s.NEXTVAL

1348: CLOSE csr_exclusion;
1349:
1350: IF l_flag_exclusion <> 'Y' then
1351: IF l_flag_action_type not in ('I','B','V') then
1352: SELECT pay_assignment_actions_s.NEXTVAL
1353: INTO l_actid
1354: FROM DUAL;
1355:
1356: hr_utility.set_location('INSIDE IF',18);

Line 1378: SELECT pay_assignment_actions_s.NEXTVAL

1374: FETCH csr_exclusion into l_flag_exclusion, l_flag_action_type;
1375: CLOSE csr_exclusion;
1376:
1377: IF l_flag_exclusion <> 'Y' then
1378: SELECT pay_assignment_actions_s.NEXTVAL
1379: INTO l_actid
1380: FROM DUAL;
1381: hr_utility.set_location('INSIDE ELSE',18);
1382: hr_utility.set_location('Insert asg actions asg_id '||to_char(csr_select_asg_rec.assignment_id),18);

Line 1429: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;

1425: l_arch_works_number pay_action_information.action_information14%TYPE
1426: DEFAULT ' '; --BUG 3306202 Added default value
1427: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1428: l_arch_person_id per_assignments_f.person_id%TYPE;
1429: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1430: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1431: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1432: l_arch_surname pay_action_information.action_information29%TYPE;
1433: l_arch_first_name pay_action_information.action_information28%TYPE;

Line 1430: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;

1426: DEFAULT ' '; --BUG 3306202 Added default value
1427: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1428: l_arch_person_id per_assignments_f.person_id%TYPE;
1429: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1430: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1431: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1432: l_arch_surname pay_action_information.action_information29%TYPE;
1433: l_arch_first_name pay_action_information.action_information28%TYPE;
1434: l_arch_dob pay_action_information.action_information25%TYPE;

Line 1442: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;

1438: l_arch_address_line4 pay_action_information.action_information9%TYPE; -- BUG 4066315
1439: l_length_address_line2 NUMBER; -- BUG 4066315
1440: l_available_space NUMBER; -- BUG 4066315
1441: l_arch_hire_date pay_action_information.action_information24%TYPE;
1442: l_arch_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
1443: l_arch_annual_tax_credit pay_action_information.action_information26%TYPE;
1444: l_arch_term_date pay_action_information.action_information25%TYPE;
1445: l_arch_mothers_name per_people_f.per_information1%TYPE;
1446: l_arch_totwks_insurble_emplmnt pay_run_result_values.result_value%TYPE;

Line 1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;

1479: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1480: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1482: l_asg_id per_assignments_f.assignment_id%TYPE;
1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535

Line 1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;

1480: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1482: l_asg_id per_assignments_f.assignment_id%TYPE;
1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535
1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153

Line 1556: pay_assignment_actions paa,

1552: CURSOR get_action_type(p_action_id number)
1553: IS
1554: SELECT paa.assignment_action_id,ppa.action_type
1555: FROM pay_action_interlocks pal,
1556: pay_assignment_actions paa,
1557: pay_payroll_actions ppa
1558: WHERE pal.locked_action_id = p_action_id
1559: AND pal.locking_action_id = paa.assignment_action_id
1560: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1574: pay_assignment_actions paa

1570:
1571: /*CURSOR get_action_type(p_action_id number) is
1572: select ppa.action_type, ppa.report_type
1573: from pay_payroll_actions ppa,
1574: pay_assignment_actions paa
1575: where ppa.payroll_action_id = paa.payroll_action_id
1576: and paa.source_action_id IS NULL
1577: and paa.assignment_action_id = p_action_id;*/
1578:

Line 1586: pay_assignment_actions paa,

1582: /*CURSOR csr_latest_p30_action (p_asg_act_id NUMBER)
1583: IS
1584: SELECT paa.assignment_action_id
1585: FROM pay_action_interlocks pal,
1586: pay_assignment_actions paa,
1587: pay_payroll_actions ppa,
1588: pay_action_information pai
1589: WHERE pal.locked_action_id = p_asg_act_id
1590: AND pal.locking_action_id = paa.assignment_action_id

Line 1607: pay_assignment_actions paa,

1603: CURSOR csr_latest_prepay_action (p_asg_act_id NUMBER)
1604: IS
1605: SELECT paa.assignment_action_id
1606: FROM pay_action_interlocks pal,
1607: pay_assignment_actions paa,
1608: pay_payroll_actions ppa
1609: WHERE pal.locked_action_id = p_asg_act_id
1610: AND pal.locking_action_id = paa.assignment_action_id
1611: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2006: pay_assignment_actions paa,

2002: 0
2003: ) -- Q1_Previous_Emp_USC
2004: --14659262
2005: FROM pay_action_interlocks pai,
2006: pay_assignment_actions paa,
2007: per_people_f ppf,
2008: per_periods_of_service pps,
2009: per_assignments_f paf,
2010: per_addresses pad,

Line 2243: FROM pay_assignment_actions paa,

2239: ),
2240: 0
2241: ) -- Q1_Previous_Emp_USC
2242: --14659262
2243: FROM pay_assignment_actions paa,
2244: per_people_f ppf,
2245: per_periods_of_service pps,
2246: per_assignments_f paf,
2247: per_addresses pad,

Line 2387: from pay_assignment_actions

2383: ORDER BY payef.effective_end_date desc;
2384:
2385: CURSOR get_assignment_id is
2386: select payroll_action_id,assignment_id,chunk_number
2387: from pay_assignment_actions
2388: where assignment_action_id = p_assactid;
2389:
2390: /*** Cursors for Previous employment balances */
2391: CURSOR c_get_periods_of_service(v_person_id NUMBER,

Line 2425: FROM pay_assignment_Actions paa,

2421:
2422: /*
2423: CURSOR c_get_max_aact(p_pds_id NUMBER) IS
2424: SELECT max(paa.assignment_action_id)
2425: FROM pay_assignment_Actions paa,
2426: pay_payroll_actions ppa
2427: -- ,per_time_periods ptp -- removed to improve performance 4771780
2428: WHERE paa.assignment_id in (SELECT assignment_id
2429: FROM per_assignments_f

Line 2448: FROM pay_assignment_Actions paa,

2444: c_ppsn varchar2,
2445: c_person_id NUMBER) IS
2446: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2447: paa.assignment_action_id),16))
2448: FROM pay_assignment_Actions paa,
2449: pay_payroll_actions ppa
2450:
2451: WHERE ( (c_ppsn is null and paa.assignment_id in (SELECT paf.assignment_id
2452: FROM per_assignments_f paf

Line 2481: pay_assignment_actions paa

2477: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2478: paf.primary_flag,
2479: paf.assignment_id
2480: from per_assignments_f paf,
2481: pay_assignment_actions paa
2482: where paf.assignment_id = paa.assignment_id
2483: and paa.assignment_action_id = p_action_id
2484: and paf.effective_start_date <= l_end_date
2485: and paf.effective_end_date >= l_start_date;

Line 2496: pay_assignment_actions paa

2492: paf.primary_flag,
2493: paf.assignment_id,
2494: max(effective_end_date) end_date
2495: from per_assignments_f paf,
2496: pay_assignment_actions paa
2497: where paf.assignment_id = paa.assignment_id
2498: and paa.assignment_action_id = p_action_id
2499: and paf.effective_start_date <= l_end_date
2500: and paf.effective_end_date >= l_start_date

Line 2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;

2531: cnt number;
2532: v_action_type pay_payroll_actions.action_type%TYPE;
2533: v_report_type pay_payroll_actions.report_type%TYPE;
2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;

Line 2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;

2532: v_action_type pay_payroll_actions.action_type%TYPE;
2533: v_report_type pay_payroll_actions.report_type%TYPE;
2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2540: v_date date;

Line 2538: v_chunk pay_assignment_actions.chunk_number%TYPE;

2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2540: v_date date;
2541: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2542: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 2542: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;

2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2540: v_date date;
2541: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2542: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2543: l_cnt number;
2544: l_pl_cnt number; --8259095
2545: -- for P60 enhancement.
2546: l_prev_pay pay_action_information.action_information4%TYPE;

Line 2575: l_child_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2571: from per_assignment_extra_info
2572: where assignment_id = p_asg_id
2573: and aei_information_category = 'IE_ASG_OVERRIDE';
2574:
2575: l_child_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2576:
2577: CURSOR csr_child_actions(p_asg_id number) IS
2578: SELECT paa.assignment_action_id child_assignment_action_id
2579: --,prt.run_method run_type

Line 2580: FROM pay_assignment_actions paa,

2576:
2577: CURSOR csr_child_actions(p_asg_id number) IS
2578: SELECT paa.assignment_action_id child_assignment_action_id
2579: --,prt.run_method run_type
2580: FROM pay_assignment_actions paa,
2581: pay_run_types_f prt
2582: WHERE paa.run_type_id = prt.run_type_id
2583: AND prt.run_method IN ('N','P')
2584: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2588: FROM pay_assignment_actions paa,

2584: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2585: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2586: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2587: paa.assignment_action_id),16)) child_assignment_action_id
2588: FROM pay_assignment_actions paa,
2589: pay_payroll_actions ppa
2590: WHERE paa.assignment_id = p_asg_id
2591: AND ppa.payroll_action_id = paa.payroll_action_id
2592: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))

Line 2616: FROM pay_assignment_actions paa,

2612: CURSOR csr_min_max_asg_act_yr (p_assignment_id NUMBER) IS
2613: SELECT
2614: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_max
2615: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min
2616: FROM pay_assignment_actions paa,
2617: pay_payroll_actions ppa
2618: WHERE ppa.payroll_action_id = paa.payroll_action_id
2619: and paa.assignment_id = p_assignment_id
2620: and ppa.action_type in ('R','Q')

Line 2624: l_min_act_id pay_assignment_actions.assignment_action_id%TYPE;

2620: and ppa.action_type in ('R','Q')
2621: and paa.source_action_id is null
2622: AND ppa.effective_date between l_start_date AND l_end_date;
2623:
2624: l_min_act_id pay_assignment_actions.assignment_action_id%TYPE;
2625: l_max_act_id pay_assignment_actions.assignment_action_id%TYPE;
2626:
2627:
2628: CURSOR csr_exclusion_flag (p_action_id_min NUMBER, p_action_id_max NUMBER, p_asg_id NUMBER) IS

Line 2625: l_max_act_id pay_assignment_actions.assignment_action_id%TYPE;

2621: and paa.source_action_id is null
2622: AND ppa.effective_date between l_start_date AND l_end_date;
2623:
2624: l_min_act_id pay_assignment_actions.assignment_action_id%TYPE;
2625: l_max_act_id pay_assignment_actions.assignment_action_id%TYPE;
2626:
2627:
2628: CURSOR csr_exclusion_flag (p_action_id_min NUMBER, p_action_id_max NUMBER, p_asg_id NUMBER) IS
2629: SELECT count(1) cnt

Line 2634: pay_assignment_actions paa,

2630: FROM pay_run_result_values prrv,
2631: pay_run_results prr,
2632: pay_input_values_f pivf,
2633: pay_element_types_f pet,
2634: pay_assignment_actions paa,
2635: pay_payroll_actions ppa
2636: WHERE ppa.payroll_action_id= paa.payroll_action_id
2637: AND paa.assignment_id = p_asg_id
2638: AND ((paa.source_action_id between p_action_id_min AND p_action_id_max

Line 6832: SELECT pay_assignment_actions_s.NEXTVAL

6828: action. The need for having child assignment action for
6829: retry of pay_payroll action.
6830: */
6831: hr_utility.set_location('Inside Else ..',2002);
6832: SELECT pay_assignment_actions_s.NEXTVAL
6833: INTO l_actid
6834: FROM DUAL;
6835: OPEN get_assignment_id;
6836: FETCH get_assignment_id into v_payroll_action_id,v_assignment_id,v_chunk;

Line 7405: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id

7401: hr_utility.set_location('Before Update',1009);
7402: /* update assignment actions */
7403:
7404: IF v_assignment_id <> l_max_assignment_id THEN
7405: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
7406: WHERE assignment_action_id = p_assactid
7407: AND payroll_action_id= v_payroll_action_id;
7408:
7409: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id

Line 7409: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id

7405: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
7406: WHERE assignment_action_id = p_assactid
7407: AND payroll_action_id= v_payroll_action_id;
7408:
7409: UPDATE pay_assignment_actions SET assignment_id = l_max_assignment_id
7410: WHERE source_action_id = p_assactid
7411: AND payroll_action_id = v_payroll_action_id;
7412: END IF;
7413:

Line 7740: pay_assignment_actions paa,

7736: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
7737: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
7738: FROM per_people_f ppf,
7739: per_assignments_f paf,
7740: pay_assignment_actions paa,
7741: pay_payroll_actions ppa,
7742: per_time_periods ptp
7743: WHERE
7744: ppf.person_id = p_person_id

Line 7786: pay_assignment_actions paa,

7782: paa.assignment_action_id,
7783: trim(rrv1.result_value) result_value
7784: FROM per_people_f per,
7785: per_assignments_f asg,
7786: pay_assignment_actions paa,
7787: pay_payroll_actions ppa,
7788: per_time_periods ptp,
7789: pay_run_results prr,
7790: pay_element_types_f pet,

Line 7908: pay_assignment_actions paa,

7904: )
7905: ) class_name
7906: FROM per_people_f per,
7907: per_assignments_f asg,
7908: pay_assignment_actions paa,
7909: pay_payroll_actions ppa,
7910: per_time_periods ptp,
7911: pay_run_results prr,
7912: pay_element_types_f pet,

Line 8018: pay_assignment_actions paa,

8014: MIN (ptp.end_date) min_eff_date,
8015: ptp.time_period_id
8016: FROM per_people_f per,
8017: per_assignments_f asg,
8018: pay_assignment_actions paa,
8019: pay_payroll_actions ppa,
8020: per_time_periods ptp,
8021: pay_run_results prr,
8022: pay_element_types_f pet,

Line 8812: l_get_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

8808: RETURN NUMBER
8809: AS
8810:
8811: l_total_weeks NUMBER (4) := 0; --Bug No 4555227
8812: l_get_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
8813: --
8814: --
8815:
8816: BEGIN