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_US_GEO_UPD_PKG dependencies on PAY_BALANCE_CONTEXT_VALUES

Line 972: --Retrieve affected rows in the pay_balance_context_values table

968: and pugu.process_type = g_process_type
969: and pugu.id = g_geo_phase_id);
970: fac_rec fac_cur%ROWTYPE;
971:
972: --Retrieve affected rows in the pay_balance_context_values table
973: --using the latest_balance_id's from the pay_person_latest_balances
974: --table.
975: --Since we can join by the pk of the table we do not need any more logic
976: --in the balance_contexts procedure.

Line 982: pay_balance_context_values pbcv,

978: CURSOR pbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
979: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
980: plb.assignment_action_id
981: FROM pay_assignment_actions paa,
982: pay_balance_context_values pbcv,
983: pay_person_latest_balances plb,
984: ff_contexts fcon
985: WHERE paa.assignment_id = assign_id
986: AND paa.assignment_action_id = plb.assignment_action_id

Line 996: and pugu.table_name = 'PAY_BALANCE_CONTEXT_VALUES'

992: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
993: where pugu.assignment_id = assign_id
994: and pugu.table_value_id = plb.latest_balance_id
995: and pugu.old_juri_code = geocode
996: and pugu.table_name = 'PAY_BALANCE_CONTEXT_VALUES'
997: and pugu.process_mode = g_mode
998: and pugu.process_type = g_process_type
999: and pugu.id = g_geo_phase_id);
1000:

Line 1003: --Retrieve affected rows in the pay_balance_context_values table

999: and pugu.id = g_geo_phase_id);
1000:
1001: pbcv_rec pbcv_cur%ROWTYPE;
1002:
1003: --Retrieve affected rows in the pay_balance_context_values table
1004: --using the latest_balance_id's from the pay_assignment_latest_balances
1005: --table.
1006: CURSOR pacv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1007: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,

Line 1010: pay_balance_context_values pbcv,

1006: CURSOR pacv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1007: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1008: plb.assignment_action_id
1009: FROM ff_contexts fcon,
1010: pay_balance_context_values pbcv,
1011: pay_assignment_latest_balances plb
1012: WHERE plb.assignment_id = assign_id
1013: AND pbcv.latest_balance_id = plb.latest_balance_id
1014: AND pbcv.value = geocode

Line 1021: and pugu.table_name = 'PAY_BALANCE_CONTEXT_VALUES'

1017: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1018: where pugu.assignment_id = assign_id
1019: and pugu.table_value_id = plb.latest_balance_id
1020: and pugu.old_juri_code = geocode
1021: and pugu.table_name = 'PAY_BALANCE_CONTEXT_VALUES'
1022: and pugu.process_mode = g_mode
1023: and pugu.process_type = g_process_type
1024: and pugu.id = g_geo_phase_id);
1025:

Line 1030: --Retrieve affected rows in the pay_balance_context_values table

1026:
1027: pacv_rec pacv_cur%ROWTYPE;
1028:
1029: -- Rosie Monge 10/17/2005 Bug 4602222
1030: --Retrieve affected rows in the pay_balance_context_values table
1031: --using the latest_balance_id's from the pay_latest_balances
1032: --table.
1033:
1034: CURSOR plbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS

Line 1038: pay_balance_context_values pbcv,

1034: CURSOR plbcv_cur(geocode VARCHAR2, assign_id NUMBER, personid NUMBER) IS
1035: SELECT distinct pbcv.context_id, pbcv.value, pbcv.latest_balance_id,
1036: plb.assignment_action_id
1037: FROM ff_contexts fcon,
1038: pay_balance_context_values pbcv,
1039: pay_latest_balances plb
1040: WHERE plb.assignment_id = assign_id
1041: AND pbcv.latest_balance_id = plb.latest_balance_id
1042: AND pbcv.value = geocode

Line 1049: and pugu.table_name = 'PAY_BALANCE_CONTEXT_VALUES'

1045: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1046: where pugu.assignment_id = assign_id
1047: and pugu.table_value_id = plb.latest_balance_id
1048: and pugu.old_juri_code = geocode
1049: and pugu.table_name = 'PAY_BALANCE_CONTEXT_VALUES'
1050: and pugu.process_mode = g_mode
1051: and pugu.process_type = g_process_type
1052: and pugu.id = g_geo_phase_id);
1053:

Line 1935: UPDATE pay_balance_context_values

1931: hr_utility.trace('Before update of latest balances context for assignment_action_id: '||to_char(p_assign_act_id));
1932:
1933: IF G_MODE = 'UPGRADE' THEN
1934:
1935: UPDATE pay_balance_context_values
1936: SET value = p_new_juri_code
1937: WHERE value = p_old_juri_code
1938: AND context_id = p_context_id
1939: AND latest_balance_id = p_lat_bal_id;

Line 1950: p_location => 'PAY_BALANCE_CONTEXT_VALUES',

1946: p_person_id => p_person_id,
1947: p_assign_id => p_assign_id,
1948: p_old_juri_code => p_old_juri_code,
1949: p_new_juri_code => p_new_juri_code,
1950: p_location => 'PAY_BALANCE_CONTEXT_VALUES',
1951: p_id => p_lat_bal_id);
1952:
1953: ELSE
1954:

Line 1963: p_location => 'PAY_BALANCE_CONTEXT_VALUES',

1959: p_person_id => p_person_id,
1960: p_assign_id => p_assign_id,
1961: p_old_juri_code => p_old_juri_code,
1962: p_new_juri_code => p_new_juri_code,
1963: p_location => 'PAY_BALANCE_CONTEXT_VALUES',
1964: p_id => p_lat_bal_id);
1965:
1966: END IF;
1967: