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

Line 1000: SELECT pay_assignment_actions_s.nextval

996: LOOP
997: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
998: FETCH csr_get_asg INTO l_assg_id;
999: EXIT WHEN csr_get_asg%NOTFOUND;
1000: SELECT pay_assignment_actions_s.nextval
1001: INTO lockingactid
1002: FROM dual;
1003:
1004: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);

Line 1005: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

1001: INTO lockingactid
1002: FROM dual;
1003:
1004: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);
1005: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
1006: /* hr_nonrun_asact.insact(lockingactid => lockingactid
1007: ,assignid => l_assg_id
1008: ,pactid => pactid
1009: ,chunk => chunk

Line 1155: FROM pay_assignment_actions paa,

1151: SELECT /*+ USE_NL(paa, ppa) */
1152: -- max(paa.assignment_action_id) assignment_action_id
1153: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1154: paa.assignment_action_id),16)) assignment_action_id /* 9852564 */
1155: FROM pay_assignment_actions paa,
1156: pay_payroll_actions ppa
1157: WHERE paa.assignment_id = p_asg_id
1158: AND ppa.payroll_action_id = paa.payroll_action_id
1159: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 1200: pay_assignment_actions paa

1196: p_payroll_id pay_all_payrolls.payroll_id%type) IS
1197: select count(ptp.time_period_id)
1198: from per_time_periods ptp,
1199: pay_payroll_actions ppa,
1200: pay_assignment_actions paa
1201: where ptp.payroll_id = p_payroll_id
1202: and ptp.regular_payment_date between g_qtr_start_date and g_qtr_end_date
1203: and ppa.payroll_id=p_payroll_id
1204: and ppa.time_period_id=ptp.time_period_id

Line 1222: pay_assignment_actions paa

1218: from per_time_periods ptp
1219: where ptp.payroll_id = p_payroll_id
1220: and ptp.time_period_id in ( select ppa.time_period_id
1221: from pay_payroll_actions ppa,
1222: pay_assignment_actions paa
1223: where ppa.payroll_id=p_payroll_id
1224: and ppa.action_type in ('R', 'Q', 'I', 'V','B')
1225: and ppa.payroll_action_id=paa.payroll_action_id
1226: and paa.assignment_id=p_assignment_id

Line 2728: FROM pay_assignment_actions paa,

2724: OR g_assignment_set_id IS NULL)
2725: --
2726: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2727: prt.run_method run_type
2728: FROM pay_assignment_actions paa,
2729: pay_run_types_f prt
2730: WHERE paa.run_type_id = prt.run_type_id
2731: AND prt.run_method IN ('N','P')
2732: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2735: FROM pay_assignment_actions paa,

2731: AND prt.run_method IN ('N','P')
2732: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2733: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2734: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2735: FROM pay_assignment_actions paa,
2736: pay_payroll_actions ppa
2737: WHERE
2738: paa.assignment_id = paaf.assignment_id
2739: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2839: FROM pay_assignment_actions paa,

2835: OR g_assignment_set_id IS NULL)
2836: --
2837: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2838: prt.run_method run_type
2839: FROM pay_assignment_actions paa,
2840: pay_run_types_f prt
2841: WHERE paa.run_type_id = prt.run_type_id
2842: AND prt.run_method IN ('N','P')
2843: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2846: FROM pay_assignment_actions paa,

2842: AND prt.run_method IN ('N','P')
2843: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2844: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2845: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2846: FROM pay_assignment_actions paa,
2847: pay_payroll_actions ppa
2848: WHERE
2849: paa.assignment_id = paaf.assignment_id
2850: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2958: FROM pay_assignment_actions paa,

2954: /*
2955: and g_qtr_start_date between paaf.effective_start_date and paaf.effective_end_date
2956: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2957: prt.run_method run_type
2958: FROM pay_assignment_actions paa,
2959: pay_run_types_f prt
2960: WHERE paa.run_type_id = prt.run_type_id
2961: AND prt.run_method IN ('N','P')
2962: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2965: FROM pay_assignment_actions paa,

2961: AND prt.run_method IN ('N','P')
2962: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2963: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2964: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2965: FROM pay_assignment_actions paa,
2966: pay_payroll_actions ppa
2967: WHERE
2968: paa.assignment_id = paaf.assignment_id
2969: AND ppa.payroll_action_id = paa.payroll_action_id

Line 3091: FROM pay_assignment_actions paa,

3087: OR g_assignment_set_id IS NULL)
3088: --
3089: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
3090: prt.run_method run_type
3091: FROM pay_assignment_actions paa,
3092: pay_run_types_f prt
3093: WHERE paa.run_type_id = prt.run_type_id
3094: AND prt.run_method IN ('N','P')
3095: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 3098: FROM pay_assignment_actions paa,

3094: AND prt.run_method IN ('N','P')
3095: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
3096: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
3097: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
3098: FROM pay_assignment_actions paa,
3099: pay_payroll_actions ppa
3100: WHERE
3101: paa.assignment_id = paaf.assignment_id
3102: AND ppa.payroll_action_id = paa.payroll_action_id