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

Line 937: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

933: */
934:
935: function which_retro_method
936: (
937: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
938: p_date_earned in pay_payroll_actions.date_earned%TYPE,
939: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
940: ) return varchar2 IS
941:

Line 954: pay_assignment_actions paa,

950: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
951: ) is
952: select pet.element_name
953: from pay_element_entries_f pee,
954: pay_assignment_actions paa,
955: pay_payroll_actions ppa,
956: pay_element_sets pes,
957: pay_element_type_rules petr,
958: pay_element_types_f pet

Line 975: pay_assignment_actions paa,

971: and pet.legislation_code = 'SG'
972: union all
973: select pec.classification_name
974: from pay_element_entries_f pee,
975: pay_assignment_actions paa,
976: pay_payroll_actions ppa,
977: pay_element_sets pes,
978: pay_ele_classification_rules pecr,
979: pay_element_classifications pec

Line 1084: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

1080: -- Monthly ceiling of 5,500
1081: ---------------------------------------------------------------------------
1082: function get_prev_year_ord_ytd
1083: (
1084: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1085: p_date_earned in pay_payroll_actions.date_earned%TYPE
1086: )
1087: return number is
1088: --

Line 1090: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1086: )
1087: return number is
1088: --
1089: cursor c_tax_unit_id( c_assignment_id number,
1090: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1091: is
1092: select paa.tax_unit_id
1093: from pay_assignment_actions paa
1094: where paa.assignment_id = c_assignment_id

Line 1093: from pay_assignment_actions paa

1089: cursor c_tax_unit_id( c_assignment_id number,
1090: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1091: is
1092: select paa.tax_unit_id
1093: from pay_assignment_actions paa
1094: where paa.assignment_id = c_assignment_id
1095: and paa.assignment_action_id = c_assignment_action_id;
1096: --
1097: --------------------------------------------------------------------

Line 1109: pay_assignment_actions paa,

1105: select max(paa.action_sequence),
1106: to_number(to_char(ppa.effective_date,'MM')),
1107: max(pas.person_id)
1108: from per_assignments_f pas,
1109: pay_assignment_actions paa,
1110: pay_payroll_actions ppa
1111: where (pas.person_id, paa.tax_unit_id)
1112: IN (select pas1.person_id,
1113: hsc1.segment1

Line 1135: pay_assignment_actions paa,

1131: select paa.assignment_action_id,
1132: ppa.effective_date,
1133: paa.assignment_id
1134: from per_assignments_f pas,
1135: pay_assignment_actions paa,
1136: pay_payroll_actions ppa
1137: where pas.person_id = c_person_id /* Bug 5298298 */
1138: and paa.assignment_id = pas.assignment_id
1139: and ppa.payroll_action_id = paa.payroll_action_id

Line 1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1164: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1165: g_context_tab pay_balance_pkg.t_context_tab;
1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1171: l_person_id per_assignments_f.person_id%TYPE;
1172: l_month number;

Line 1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

1165: g_context_tab pay_balance_pkg.t_context_tab;
1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1171: l_person_id per_assignments_f.person_id%TYPE;
1172: l_month number;
1173: l_effective_date date;

Line 1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

1166: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1171: l_person_id per_assignments_f.person_id%TYPE;
1172: l_month number;
1173: l_effective_date date;
1174: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 1174: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1171: l_person_id per_assignments_f.person_id%TYPE;
1172: l_month number;
1173: l_effective_date date;
1174: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1175: l_defined_bal_id number;
1176: l_prev_ord_ytd number;
1177: l_ord_mon_cap_amt number;
1178: l_ord_mon_cap_amt_b number;

Line 1294: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

1290: -- Monthly ceiling of 5,500
1291: ---------------------------------------------------------------------------
1292: function get_cur_year_ord_ytd
1293: (
1294: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1295: p_date_earned in pay_payroll_actions.date_earned%TYPE
1296: )
1297: return number is
1298: --

Line 1300: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1296: )
1297: return number is
1298: --
1299: cursor c_tax_unit_id( c_assignment_id number,
1300: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1301: is
1302: select paa.tax_unit_id
1303: from pay_assignment_actions paa
1304: where paa.assignment_id = c_assignment_id

Line 1303: from pay_assignment_actions paa

1299: cursor c_tax_unit_id( c_assignment_id number,
1300: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1301: is
1302: select paa.tax_unit_id
1303: from pay_assignment_actions paa
1304: where paa.assignment_id = c_assignment_id
1305: and paa.assignment_action_id = c_assignment_action_id;
1306: --
1307: --------------------------------------------------------------------

Line 1319: pay_assignment_actions paa,

1315: select max(paa.action_sequence),
1316: to_number(to_char(ppa.effective_date,'MM')),
1317: max(pas.person_id)
1318: from per_assignments_f pas,
1319: pay_assignment_actions paa,
1320: pay_payroll_actions ppa
1321: where (pas.person_id, paa.tax_unit_id)
1322: IN (select pas1.person_id,
1323: hsc1.segment1

Line 1345: pay_assignment_actions paa,

1341: select paa.assignment_action_id,
1342: ppa.effective_date,
1343: pas.assignment_id
1344: from per_assignments_f pas,
1345: pay_assignment_actions paa,
1346: pay_payroll_actions ppa
1347: where pas.person_id = c_person_id /* Bug 5298298 */
1348: and paa.assignment_id = pas.assignment_id
1349: and ppa.payroll_action_id = paa.payroll_action_id

Line 1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1374: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1375: g_context_tab pay_balance_pkg.t_context_tab;
1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1381: l_person_id per_assignments_f.person_id%TYPE;
1382: l_month number;

Line 1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;

1375: g_context_tab pay_balance_pkg.t_context_tab;
1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1381: l_person_id per_assignments_f.person_id%TYPE;
1382: l_month number;
1383: l_effective_date date;

Line 1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

1376: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1381: l_person_id per_assignments_f.person_id%TYPE;
1382: l_month number;
1383: l_effective_date date;
1384: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 1384: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1381: l_person_id per_assignments_f.person_id%TYPE;
1382: l_month number;
1383: l_effective_date date;
1384: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1385: l_defined_bal_id number;
1386: l_cur_ord_ytd number;
1387: l_ord_mon_cap_amt number;
1388: l_ord_mon_cap_amt_date date;

Line 1497: function get_retro_earnings( p_assignment_id in pay_assignment_actions.assignment_id%TYPE,

1493: return l_cur_ord_ytd;
1494: --
1495: end get_cur_year_ord_ytd;
1496: --
1497: function get_retro_earnings( p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1498: p_date_earned in date ) return number
1499: is
1500: cursor c_pay_element_entries
1501: is

Line 1511: from pay_assignment_actions paa1,

1507: pay_element_classifications pec
1508: where pee.assignment_id = p_assignment_id
1509: and pee.source_asg_action_id in
1510: (select paa1.assignment_action_id
1511: from pay_assignment_actions paa1,
1512: pay_payroll_actions ppa1
1513: where paa1.assignment_id = pee.assignment_id
1514: and ppa1.payroll_action_id = paa1.payroll_action_id
1515: and ppa1.action_type in ('R','Q','B','V','I')